The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hi Team,
I have created a Powerbi visual like below:
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 below:
And in the visual i have few more filters like Band and Type.
My requirement is: when only the date is selected the visual should show.
But when the combination of Band&Date // Type&Date // Band&Type&Date, the visual should not show. Below the case that should not happen.
Attaching the powerbi report here: PBIX
Kindly help me!! @Ashish_Mathur @v-lid-msft
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
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |