The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Context: I have a lot of table and matrix visuals with many measures for their columns/values. Due to the nature of my data model there are going to be a lot of blank cells across my rows. For readabillity I am wanting to apply conditional formatting to the background color of these blank cells to a darker grey and maybe apply an icon. I know that you can apply these settings for each of "series"/columns/measures, but this will take me a while to apply to every single measure across my visuals and sheets.
Is there a way to apply the conditional formatting to alter these blank cells across the whole visual, or a selected group of series/measures?
(I do not want to replace the blanks with 0's due to performance issues)
Thanks
Solved! Go to Solution.
@nickmart_bi , As of now field value(Measure) based conditional formatting does not support null/blank value. It only supported for gradient and rule-based conditional formatting
@nickmart_bi , As of now field value(Measure) based conditional formatting does not support null/blank value. It only supported for gradient and rule-based conditional formatting
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
80 | |
78 | |
47 | |
39 |
User | Count |
---|---|
148 | |
115 | |
65 | |
64 | |
53 |