Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
58 | |
47 | |
40 |
User | Count |
---|---|
115 | |
81 | |
81 | |
52 | |
39 |