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 all). How do I fix this?

 

 

Thanks! Your help is greatly appreciated! 

Ps: I am new to Power BI so you guys will see me around more often! Thank you again and have a great day!

 

Need Help
Show and Tell
Tutorial Requests

5 Replies

  • 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. 

  • Arpitb12's avatar
    Arpitb12
    Icon for Helper I rankHelper I
    2 years ago

    SelectedStudent = IF ( ISFILTERED(add the column name you are using as slicer), CALCULATE([YourCalculation], YourFilterContext), BLANK() )

    try this replace properly the values

    • Jane_D's avatar
      Jane_D
      Regular Visitor
      2 years ago

      But theres no calculation for the visual. 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.