This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hi Power BI Community!
I have this line chart:
I have also a slicer to just show one of the line charts:
Is there a way to just show one chart with values? = No zero values.
I already tried Filter greater than 0 but then nothing is shown.
Thankx for your time.
Solved! Go to Solution.
Hi @Anonymous ,
You can right click on your filed under "Axis" and de-select "Show items with no data". That should eliminate your zero line.
It should work with a filter as well. Not sure what's happening there. Can you share a screenshot of your filter?
Thanks,
Dheeraj
For your slicer, is this affecting a filter or a measure?
If you are using a measure, use an if statement with the result being BLANK() and this should remove the values from the chart.
Let me know how you get on!
@dkaushik Thanks for the reply but I already tried that:
Or this:
= No chart because if is zero than it filters everything also with other seetings on the filter
Hi @Anonymous ,
You can right click on your filed under "Axis" and de-select "Show items with no data". That should eliminate your zero line.
It should work with a filter as well. Not sure what's happening there. Can you share a screenshot of your filter?
Thanks,
Dheeraj
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 45 | |
| 38 | |
| 24 | |
| 21 | |
| 20 |