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.
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
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 |
---|---|
116 | |
102 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |