Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I would like to hide certain values in a line chart. Is there any way to do this?
As you can see in the line chart below there are values missing for "Value" and these disappear when "Average" is removed from the chart. We would however like to keep "Average" in the chart and just hide the missing values for "Value" somehow.
Can this be done?
Hi @PBNikr
Could you show some data for better analysis?
Such as the columns in the X-Axis, Value field, legend field?
Best Regard
Maggie
Hi @v-juanli-msft!
I have attached a table with sample data:
As you can see, the gaps in data occur on weekends. I am connected to a model using Direct Query and am therefore limited to what I can alter directly in Power BI.
Hi @PBNikr
It seems you face the similar problem like line chart not representing null values, you could create a measure to replace "Value" .
Measure = IF(MAX([value])=BLANK(),0,MAX([value]))
Best Regards
Maggie