Forum Discussion
Legend - Too many Values -- How to hide legend items without data for specified date range?
Hi Power Bi Community: I'm using a stacked column chart with a legend. The legend field is a parameter, so in my case I can dynamically switch it between specific project or business unit. ...
Hi Anonymous ,
I made simple samples and you can check the results below:
You can change the condition to 0 or blank, depending on your actual needs
Measure = IF(MAX('Table'[Value])<>0,1,0)An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I made simple samples and you can check the results below:
You can change the condition to 0 or blank, depending on your actual needs
Measure = IF(MAX('Table'[Value])<>0,1,0)
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.