Forum Discussion

baneworth's avatar
baneworth
Icon for Helper III rankHelper III
4 years ago
Solved

Dynamic Filter with Year and Qtr (SelectedValue)

Dear PowerBI Community,   if you could please help me out with a problem. By looking around in here i found some ideas how to solve my issue but i couldnt quite figure it out.   My KPI card shou...
Need Help
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi baneworth ,

    According to your description, here's my solution. Create a measure.

     

    Title =
IF (
    COUNTROWS ( ALLSELECTED ( 'Calendar'[Qtr] ) ) = 1,
    CONVERT ( SELECTEDVALUE ( 'Calendar'[Qtr] ), STRING ),
    CONVERT ( SELECTEDVALUE ( 'Calendar'[Year] ), STRING )
)

     

    Turn on the card visual title and click the fx button.

    Select the measure in the dialoge.

    Get the result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi baneworth ,

According to your description, here's my solution. Create a measure.

 

Title =
IF (
    COUNTROWS ( ALLSELECTED ( 'Calendar'[Qtr] ) ) = 1,
    CONVERT ( SELECTEDVALUE ( 'Calendar'[Qtr] ), STRING ),
    CONVERT ( SELECTEDVALUE ( 'Calendar'[Year] ), STRING )
)

 

Turn on the card visual title and click the fx button.

Select the measure in the dialoge.

Get the result.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

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

  • baneworth's avatar
    baneworth
    Icon for Helper III rankHelper III
    4 years ago

    works like a charm!!

    Thank you very much