Forum Discussion

kipi17's avatar
kipi17
New Member
7 months ago
Solved

DAX issue ISBLANK

Hello Team,   Why Show_Row is giving different outputs there?   It should be false in both the outputs since there is no selection of any region   This is probably because of the row context (r...
Need Help
  • v-dineshya's avatar
    v-dineshya
    7 months ago

    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

     

Elena_Kalina's avatar
Elena_Kalina
Solution Sage
7 months ago

Hi kipi17 

Please specify your business objective when creating this measure

kipi17's avatar
kipi17
New Member
7 months ago

hi Elena_Kalina ,

 

This is to control Power BI action; once I deselect a bar, the table should be fixed to a region, say West, 

 

Regards,

KIPI

  • Elena_Kalina's avatar
    Elena_Kalina
    Solution Sage
    7 months ago

    Hi kipi17 

    I'm a little confused by your answer. You wrote: 'once I deselect a bar, the table should be fixed to a region, say West.' That means you selected, for example, the West bar, and when you removed that selection, in the bar chart all values should be highlighted again, but in the table the value you selected should remain, is that right?

    Best regards,

    EK

    • kipi17's avatar
      kipi17
      New Member
      7 months ago

      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.

      • MasonMA's avatar
        MasonMA
        Super User
        7 months ago

        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.