Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Is it possible to hide those columns with zero values?
I tried to use filters and it doesn't work well..
Anyone can help?
Thank you!!
Solved! Go to Solution.
Hey @phchu1226 ,
unfortunately, this is not possible, at least not 100%. Here you will see my sample data:
Segment B (a column inside a cluster) carries a value in the group this, but is 0 in the group that, whereas the value of segment C is 0 in both groups.
This is how the clustered column chart will look like:
If I now create a measure like so:
check =
IF(
CALCULATE( SUM( 'Table'[Amount] ) ) = 0
, BLANK()
, 1
)
and use this measure as a visual level filter on the clustered column chart:
There still is an empty place in the group that, that represents segment B
But at least the column label 0 will not be shown any longer.
Hopefully, this provides an idea of how to tackle your challenge.
Regards,
Tom
Hey @phchu1226 ,
unfortunately, this is not possible, at least not 100%. Here you will see my sample data:
Segment B (a column inside a cluster) carries a value in the group this, but is 0 in the group that, whereas the value of segment C is 0 in both groups.
This is how the clustered column chart will look like:
If I now create a measure like so:
check =
IF(
CALCULATE( SUM( 'Table'[Amount] ) ) = 0
, BLANK()
, 1
)
and use this measure as a visual level filter on the clustered column chart:
There still is an empty place in the group that, that represents segment B
But at least the column label 0 will not be shown any longer.
Hopefully, this provides an idea of how to tackle your challenge.
Regards,
Tom
You got my point, I can hide the zero label now but the chart still exists those empty column and I cannot align other columns which contain value to the centre.
So it means that there is no such kind of feature to achieve this in PowerBI? It must show a zero/blank column there even though the column have no value?
Unfortunately, all segments that survive the visual level filter are used across all groups - in my example this & that. To some extent, this is good for the readability of the data visualization but of course, consumes more space.
I tried to apply the visual level filter, like "stock is not 0", then all the columns disappear.
How can I do the filter on only one specific column? I just wanna dont show those columns with 0.
@phchu1226 , these two ways should work.
Can you a sample pbix after removing sensitive data.
If I use this way: visual level filter , [Measure] <> 0
Which filter should I set in order to hide the columns 'C' & 'D' but 'A' & 'B' remain unchanged??
@phchu1226 , Then better to create measure as i suggested
C new = if([C] =0, blank, [C])
D new = if([D] =0, blank, [D])
@phchu1226 , Create a measure like
if([Meausre] =0, blank, [measure])
Of use visual level filter , [Measure] <> 0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |