Can We Use Measures in Row Header and Column Header Both of A Matrix Visual in Power BI ? ✨

If you need to use Multiple Measures in your Matrix Visual, or you want to use Measures in your row header and column header both this video will help you to achieve this functionality in Power BI

Get Help into Questions Related to #powerbi , #dax , #powerquery Power BI #datamodeling , #analysisservices and #powerbiservice

Follow us on LinkedIn
@PowerBIHelpline

[jayaswalraj]

Very well explained, however two areas where it should be improved:

1) it becomes two messy when you have 50 measures ( which should go in rows and 12 months in columns)

2) Measures names cannot be sorted.

Appreciate if you can suggest something on this

[andryaize]

Thank you for sharing this video. How to add budget values from another table into the same KPI? Example: Total Sales| Actual MTD|Budget MTD|Actual YTD|Budget YTD.

[valeriauc]

Thank you for sharing this, has been very helpful, does't it work for a bigger matrix? I made a matrix visual like exactly like this, but it has too many rows, so it has too many measures, therfore loads extreamly slow (25 secs any time I loaded), do you know how to solve this? I'm struggling with this visual long time ago, at my work they want it like that, but faster :( Thank you!

[harshagraj]

Hi thanks for this wonderful video. But how can we add like Region, BU columns in rows to drill down?

[bsmallika]

Hi explanation is so good and its a very useful video.

I have a doubt in main measure.
In 13, 18, 23 lines what is that field u took.
And in 13, 18, 23 lines I wanna keep 5 names of a column(managers).
How can i do that

[triadknight]

How did you custom sort the KPI column? Mine only sorts by the KPI name alphabetically and I need a custom sort on the KPIs.

[brunoargollo]

What if I need to use formatting option for each matrix column? like data bars, background colors then using this solution I lose that capability.

[vishalsonawane.]

Column header is not changed in your video?