Clear explanation and great insights presented. Truly remarkable! Thank you for your efforts.
@PowerBIHelpline
Ай бұрын
Glad you enjoyed it!
@jayaswalraj1987
6 ай бұрын
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
@pabloaschieri305
7 күн бұрын
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
7 күн бұрын
Thanks for watching. It can be sorted by a static order using some custom adjustments
@leandrohugosobrino7741
21 күн бұрын
But this is a Calculation Group
@PavanCh-q2u
3 күн бұрын
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.
@PowerBIHelpline
2 күн бұрын
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.
@PavanCh-q2u
2 күн бұрын
@@PowerBIHelpline : I tried, but no success. By default +/- will always start for each field (like +category, etc). Any references are much appreciated.
@vishalsonawane.8905
3 ай бұрын
Column header is not changed in your video?
@PowerBIHelpline
3 ай бұрын
Recently posted video on dynamic column header changes, Please check it out.
@bsmallika6282
8 ай бұрын
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
8 ай бұрын
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.
@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.
@valeriauc8329
9 ай бұрын
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
9 ай бұрын
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
9 ай бұрын
@@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
@spilledgraphics
Жыл бұрын
Wuao - the master is back! 🔥🔥🔥
@triadknight95
9 ай бұрын
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
9 ай бұрын
You can assign custom ordinals for your KPIs and apply sort orders based on it.
@triadknight95
9 ай бұрын
@@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!
@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
5 ай бұрын
@@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!
@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?
Пікірлер: 40