Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
106 | |
105 | |
90 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
92 | |
88 |