Forum Discussion

Jane_D's avatar
Jane_D
Regular Visitor
2 years ago
Solved

Dashboard showing data when none is selected.

Greetings everyone.   I need help on this. As you guys can see below, I selected no students from the slicer. But the visual is still showing me the data. I need it to be blank (shows no data at al...
Need Help
Show and Tell
Tutorial Requests
  • Jane_D's avatar
    Jane_D
    2 years ago

    Has been solved ✔️

Kishore_KVN's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
2 years ago

Hello Jane_D , 
While creating the values for that calculation, use SELECTEDVALUE DAX function and make blank if nothing is selected. 
For example you can write your calculation as below:
IF(SELECTEDVALUE('Table'[Studen]) = BLANK(), BLANK(), Your_Calculation)

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Jane_D's avatar
Jane_D
Regular Visitor
2 years ago

But theres no calculation for the visuals. Like the student name, even when I selected no student, it still showed me 'Adam' there. I use a card visual for it so theres no calculation.