This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
I have these line graphs that are built with measures. When I select a filter, they display as expected.
However, when I clear the filter, I have lots of data showing on the graph(picture below). I would like nothing showing on the graph when nothing is selected.
My Dax for the measures is something like this:
Action limit =
VAR level= SELECTEDVALUE('Database'[Level])
RETURN
IF(level= BLANK(),BLANK(),
SWITCH (
level,
"level 1",3520 ,
"level 2", 3520,
"level 3", 3520,
"level 4", 352000,
"level 5", 3520000,
"level 6", 3520000 )
)
Solved! Go to Solution.
Hi @Anonymous ,
You will have create a measure to drive your slicer selection based display on your chart.
Check out following blog on how you can achieve this:
You can either display a custom message when nothing is selected in the slicer or leave the chart blank without any custom message.
Thanks,
Pragati
Hi @Anonymous ,
You will have create a measure to drive your slicer selection based display on your chart.
Check out following blog on how you can achieve this:
You can either display a custom message when nothing is selected in the slicer or leave the chart blank without any custom message.
Thanks,
Pragati
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 31 | |
| 23 | |
| 15 |
| User | Count |
|---|---|
| 76 | |
| 59 | |
| 31 | |
| 31 | |
| 25 |