Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Dear Community.
I am trying to apply background color for particular row cell based on selected month slicer. (Apr to Mar)
Color: Light Green
Ex:
If user has selected month
Month: Apr
Particular Cell : Division:Admin
Month: May
Particular Cell : Division: IT
Month: Jun
Particular Cell : Division : Transport
....... till Mar Particular Cell will be going to change.
applying row cell is possible through DAX but i am not getting how to apply color condition with multiple if condition where one by one if condition should be execute.
Thank you in adavance.
Solved! Go to Solution.
Hi @NadeemAhamed
You can create DAX like below (note that I did it on the part of the months to show how it works + you need 2 measures one for plan and second for actual) :
Result:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you for your valuable time to read and respond
Here i have attached the excel and pbix file for your reference.
pbix : https://toyotsu.box.com/s/e034h1r83v4h37weej7hwgpurpb1b100
excel : https://toyotsu.box.com/s/s3f7z18rwbze0kauuzobz6u2u564fw2l
In excel where ever cell has colored similary i have to color the cells in power bi table or matrix based on month slicer.
Hi @NadeemAhamed
You can create DAX like below (note that I did it on the part of the months to show how it works + you need 2 measures one for plan and second for actual) :
Result:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
68 | |
67 |