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
Awesome video, is there a chance to sort columns by a specific order? Measures can be sorted using a custom order column, but what about the columns? Thanks!
@@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!
Is it possible to have a image for every row (this first row field will be like index number (1,2,3) and then start +/- for category from second row header as part of matrix visual. I tried, but the image is coming after +/-. Is there any trick/tip.
Image for every Row header field? Images will not come before +/- in the same column. you may need to add additional field before the +/- field and adjust the width.
@@PowerBIHelpline : I tried, but no success. By default +/- will always start for each field (like +category, etc). Any references are much appreciated.
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
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.
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!
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.
@@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
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.
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.
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
@@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!
Clear explanation and great insights presented. Truly remarkable! Thank you for your efforts.
Glad you enjoyed it!
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
Simply awesome 👍👍
Thank you! Cheers!
Wuao - the master is back! 🔥🔥🔥
Great. You solved big problem
Glad to know it was helpful.
Awesome video, is there a chance to sort columns by a specific order? Measures can be sorted using a custom order column, but what about the columns? Thanks!
Thanks for watching. It can be sorted by a static order using some custom adjustments
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.
You can assign custom ordinals for your KPIs and apply sort orders based on it.
@@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!
Is it possible to have a image for every row (this first row field will be like index number (1,2,3) and then start +/- for category from second row header as part of matrix visual. I tried, but the image is coming after +/-. Is there any trick/tip.
Image for every Row header field? Images will not come before +/- in the same column. you may need to add additional field before the +/- field and adjust the width.
@@PowerBIHelpline : I tried, but no success. By default +/- will always start for each field (like +category, etc). Any references are much appreciated.
Great 👍
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
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.
Awesome you are great 👍
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!
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.
@@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
Great Video
Thanks for the visit
thanks
Thank you! Cheers!
Hi thanks for this wonderful video. But how can we add like Region,BU columns in rows to drill down?
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.
@@PowerBIHelpline Hi thanks for the reply no its not working as expected. How can i send you a sample pbix file?
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.
Thanks for watching.
Column header is not changed in your video?
Recently posted video on dynamic column header changes, Please check it out.
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.
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
@@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!
Superbbbbbbbbb
Thanks 🤗
But this is a Calculation Group