Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi @PetrM ,
Hope you are doing well.
If I understand your requirement correctly then I think you can use ISFILTERED() DAX Formula to get control over the Total row color. You can use ISFILTERED() function inside IF() function with the color measure you have.
If you have any queries then please let me know or you can also share your pbix file so that I can help you.
If this give you any idea or helps you in your problem then give it a kudos and please accept it as a solution.
Thank you.
Thank you @KeyurPatel14 - I was playing with the ISFILTERED() since that is what ChatGPT also recommended. But I was unable to make it work.
Here is a picture and a pbix example.
Access was required to download the file so I have sent the request kindly accept it so that I can download the pbix.
Thank you.
I'm sorry, I believed I created a public link. It should be ok now. Thank you for not giving up.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |