Forum Discussion

chetan8080's avatar
chetan8080
Icon for Helper II rankHelper II
1 year ago
Solved

DAX Measure Not Showing Correct Slicer State (All Selected, No Selection, Partial Selection)

Hello Power BI Community, I am facing an issue with a DAX measure intended to dynamically display the state of a region slicer. The goal is to show one of three messages based on the user's selectio...
Need Help
Tips and Tricks
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    Hi chetan8080 , 

    Thanks for the response.

    Could you please provide sample data that fully represents the issue or question you're referring to? Kindly ensure the data is in a usable format (e.g., PBIX,Excel or CSV) rather than a screenshot, and does not contain any sensitive or unrelated information.

    Looking forward to your response.

    Best regards,
    Lakshmi.

     

chetan8080's avatar
chetan8080
Icon for Helper II rankHelper II
1 year ago

No, when 'Select All' is unchecked/nothing is selected the message should be "Please Select a Region".
to be precise 

I want the measure to display:

  1. "Please select a region" when no items are selected in the slicer.

  2. "All regions selected" when all regions are selected.

  3. "Regions selected: [List of regions]" when one to nine regions are selected.

 

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
1 year ago

Hi rohit1991  what would you think about this request?