Forum Discussion

New_be's avatar
New_be
Helper V
5 years ago

Show card using dynamic selection

hi expert! 😁

 

I have a report & i want to show card that will show a certain value (measure) based on certain selection. Below i will show the example.

 

This is example. I have a pie chart, and i want if i click at a certain section, it will show me that particular value for that section.

 

Below is the list of the section from my section table:

 

And for the card, i want to show the particular value for each section like below image:

For example if i click "FRS" in the pie chart, it will show me 0.47% from framesawing. The measure is;

    REJECT_YDA = 
        CALCULATE (
        DIVIDE ( [TOTAL REJECT SQFT], [TOTAL PRD SQFT] )
        )
 

The logic for the card is, 

      if i click [section] then it will show [percentages measure], else "Please click the section"

 

Thanks in advance for your cooperation & fast response! 

Best regards.

          

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    New_be , As One measure, can not have two data types. So please make sure you format your % measure

    if(isfiltered(Table[Section]), [REJECT_YDA] & "" , "Please click the section")

    or

     

    if(isfiltered(Table[Block]) || isfiltered(Table[Section]), [REJECT_YDA] & "" , "Please click the section")

     

    In place of [REJECT_YDA] & "" give you formatting % measure in text format

    check for format https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

    • New_be's avatar
      New_be
      Helper V
      5 years ago

      alright, thank you so much Mr amitchandak . I will try your way, & then i will feedback again your reply