Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a Matrix visual that does a simple count of a column.
The conditional formatting is configured to show the red color and the Lowest/mininum end of the count spectrum.
What I can't figure out is how to configure (via the Filter Pane) a filter so it only shows only rows that have a blank/red entry.
I tried configuring the Visual count filter so it only showed values = 0 and that blanked out the entire visual so no records were shown.
Does anyone know if there's a way to filter based on rows having partial 0 values in this particular case?
Thanks,
Mike
@mlee ,
The conditional formatting is configured to show the red color and the Lowest/mininum end of the count spectrum.
What I can't figure out is how to configure (via the Filter Pane) a filter so it only shows only rows that have a blank/red entry.
I tried configuring the Visual count filter so it only showed values = 0 and that blanked out the entire visual so no records were shown.
Does anyone know if there's a way to filter based on rows having partial 0 values in this particular case?
Thanks,
Mike
Could you share some sample data and clarify more details about your expected result?
Regards,
Jimmy Tao
User | Count |
---|---|
117 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
62 | |
55 |