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
Check out our website www.powerbihelpline.com and blog-post. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic.
Follow us on LinkedIn
/ power-bi-helpline-22a2...
Email- [e-mail]
@PowerBIHelpline

[@jayaswalraj1987]

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

[@arbazahmad7177]

Great 👍

[@spilledgraphics]

Wuao - the master is back! 🔥🔥🔥

[@meghab2910]

Awesome you are great 👍

[@distrilanalytics]

Great. You solved big problem

[@PowerBIHelpline]

Glad to know it was helpful.

[@bharatarse1503]

Simply awesome 👍👍

[@PowerBIHelpline]

Thank you! Cheers!

[@andrya92ize]

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.

[@PowerBIHelpline]

Thanks for watching.

[@ymohamed3154]

Great Video

[@PowerBIHelpline]

Thanks for the visit

[@TheJaebeomPark]

thanks

[@PowerBIHelpline]

Thank you! Cheers!

[@bsmallika6282]

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

[@PowerBIHelpline]

Glad to know you liked it.
That is a Date column from the Calendar table called dim_date, which i have added to calculate Time Intelligence calculations (MTD, QTD or YTD).
Though it is not must needed, but it is important to have a separate calendar table for such time intelligence calculations because of multiple reasons.

[@valeriauc8329]

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!

[@PowerBIHelpline]

Optimizing DAX and visual's query is absolutely important when we want to enable such functionalities with complex measures and/or in bigger Matrix configuration. There are multiple technique and best practices to follow for the same.
I would suggest you to follow all the best practices while authoring your DAX and formatting the visuals.

[@valeriauc8329]

​@@PowerBIHelpline thanks very much for reply, I do try to use best practices, but I'll try to optimize my measures as much as possible like you mentioned :D

[@harshagraj]

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

[@PowerBIHelpline]

You can Use Region/BU as the First Row header, then keep this KPI column as 2nd row header. It will work as you are expecting. because Region or BU will only filter the data for its relevant part. If it doesn't work your way, send us a query.

[@harshagraj]

@@PowerBIHelpline Hi thanks for the reply no its not working as expected. How can i send you a sample pbix file?

[@triadknight95]

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.

[@PowerBIHelpline]

You can assign custom ordinals for your KPIs and apply sort orders based on it.

[@triadknight95]

@@PowerBIHelpline Thank you. For others, I had to create another table that included the KPI name and sort order, relate it back to the KPI track table and use RELATED() in a calc column to bring the KPI sort order into the KPI track table and sort the KPI names from the new calc column. it worked!

[@laiqmehdi8704]

Superbbbbbbbbb

[@PowerBIHelpline]

Thanks 🤗

[@brunoargollo1993]

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.

[@PowerBIHelpline]

Not the data bars, but you can easily format the background or font colors dynamically, by creating an appropriate format DAX measure for the same, which will dynamically identify the position and validate with the conditions to format it. you can also add icons as well

[@AgborEnow-bu5hp]

@@PowerBIHelplineI have tried different techniques to apply conditional formatting but it’s not working do mind throwing more light on this with an example? Thank you!

[@vishalsonawane.8905]

Column header is not changed in your video?

[@PowerBIHelpline]

Recently posted video on dynamic column header changes, Please check it out.