Forum Discussion
DAX issue ISBLANK
Hi kipi17 ,
Thank you for reaching out to the Microsoft Community Forum.
What you are seeing is correct Power BI behavior, and it is a hard limitation, not a DAX bug. DAX CANNOT “remember” a previous slicer selection after it is deselected. Measures are stateless. Once the slicer is cleared, the information is gone. That’s why your table shows all regions again. By using slicers, you can't achieve the desired result. But by using the Bookmarks + Buttons, you can achieve the desired result.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Desired Behavior: When a user selects West/East/Central, the report should display only the corresponding region’s sales, which is the default behavior of Power BI filters.
However, if the user deselects the region, it should retain the previously selected region instead of reverting to “Show All.”
For example:
- If I click West, it should filter to the West region.
- If I click West again, it should remain on West, rather than showing all regions (which is Power BI’s default behavior).
The same logic should apply to East and Central.
I dont think this would be natively possible.
When you click to deselect the region, Power BI visuals clear the filters. This behavior would have been hard‑coded and cannot be modified in visual interactions. If you look for workarounds, you may test with disconnected Region table with no physical relationship so that you can use DAX to drive your measures based on selection.
Yes, but I am not sure if we can do this even with disconnected tables
Yes, not currently possible. Power BI doesn’t retain previous slicer selections. It only knows what’s currently selected, so if nothing is selected or previous selections have been deselected, it treats it as “select all.”
