Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.