Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter/Slicer Requirement

hi Team, I have created a Powerbi visual like below: Link    When i click the date, the visual will appear and when no date is selected, it will show a message to select a date. It will be like b...
Need Help
sturlaws's avatar
sturlaws
Resident Rockstar
6 years ago

Hi Anonymous,

what should happen if not date is selected, but there is one value for, say, Band?

here are measures which will show the visual and message when only of your slicers is active:

Filter = SWITCH(true();
    ISFILTERED('Table'[Date]) && NOT(ISFILTERED('Table'[Band])) && NOT(ISFILTERED('Table'[Type])) && NOT(ISFILTERED('Table'[Name]));"#fffffff";
    ISFILTERED('Table'[Band]) && NOT(ISFILTERED('Table'[Date])) && NOT(ISFILTERED('Table'[Type])) && NOT(ISFILTERED('Table'[Name]));"#fffffff";
    ISFILTERED('Table'[Type]) && NOT(ISFILTERED('Table'[Date])) && NOT(ISFILTERED('Table'[Band])) && NOT(ISFILTERED('Table'[Name]));"#fffffff";
    ISFILTERED('Table'[Name]) && NOT(ISFILTERED('Table'[Date])) && NOT(ISFILTERED('Table'[Band])) && NOT(ISFILTERED('Table'[Type]));"#fffffff";
    "White")
Message = SWITCH(true();
    ISFILTERED('Table'[Date]) && NOT(ISFILTERED('Table'[Band])) && NOT(ISFILTERED('Table'[Type])) && NOT(ISFILTERED('Table'[Name]));"";
    ISFILTERED('Table'[Band]) && NOT(ISFILTERED('Table'[Date])) && NOT(ISFILTERED('Table'[Type])) && NOT(ISFILTERED('Table'[Name]));"";
    ISFILTERED('Table'[Type]) && NOT(ISFILTERED('Table'[Date])) && NOT(ISFILTERED('Table'[Band])) && NOT(ISFILTERED('Table'[Name]));"";
    ISFILTERED('Table'[Name]) && NOT(ISFILTERED('Table'[Date])) && NOT(ISFILTERED('Table'[Band])) && NOT(ISFILTERED('Table'[Type]));"";
    "Please select the Date to view the Pictorial Representation")

cheers,
Sturla