Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two columns are team and colour code.
I updated the colour code against against each teams.
I am trying to apply conditional formatting based on the colour code colum in slicer row level.
Any advise please.
Solved! Go to Solution.
Interesting little trick
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @Saxon10 ,
Using a matrix and an additional column on all rows saying team you can add what you need follow the steps below:
Cat = "Team"
Final result below and in attach PBIX file.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsInteresting little trick
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thanks for your reply.
I would like to get the same result but in horzisantl wise instead of vertical wise. Is that possible?
Can you please advise.
Hi @Saxon10 ,
Using a matrix and an additional column on all rows saying team you can add what you need follow the steps below:
Cat = "Team"
Final result below and in attach PBIX file.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you so much for your help and advice.
The solution is really nice and I don't need to change the data.
Thank you so much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |