Forum Discussion

Nari1998's avatar
Nari1998
Helper II
2 years ago
Solved

Card visual not showing selected value

Hi,   I have a power bi desktop file that contains reports with visuals. On page A there is a bar chart visual that is clicked on of division to drillthrough and bring to additional information on ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Nari1998 ,

    There could be several possible causes and fixes for this problem.
    Check the filters on page B: Make sure that the division column is listed in the filters on page B. Sometimes, hidden filters can affect the card visual’s functionality. You can also try to clear all filters and slicers on page B and see if the card visual works as expected.

    Use a different measure: You can try to use a different measure to display the selected value on the card visual. For example, you can use MAX instead of SELECTEDVALUE. The measure would look like this:

    Selected Division = MAX(‘REPORTS DIM_DIVISION_PROJECT_BEU’[DIVISION])

    Use conditional formatting: You can use conditional formatting to show or hide the card visual based on the selection in the slicer. You can create a measure to check if there is a filter on the division column and display a custom value or blank when nothing is selected. You can also create another measure to render the card visual blank when nothing is selected. 

    Solved: Show custom value on card visualization when nothi... - Microsoft Fabric Community

    Show or Hide a Power BI Visual Based on Selection - Excelerator BI

     

    How to Get Your Question Answered Quickly 

     

     

    Best Regards
    Community Support Team _ Rongtie

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