Forum Discussion

ICRdatalover's avatar
ICRdatalover
Advocate I
7 years ago
Solved

Card chart

Hi everyone   I was wondering if there is any kind of graph or card just to show the exisitng applied filters, I mean, I have a Dashboard with year and month filters and I would like to have a visu...
Need Help
Tips and Tricks
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi ICRdatalover ,

     

    Pleae check my sample as below. Here I created a measure to display the values we seleted in the slicer.

     

    Measure = IF(ISFILTERED('Table'[Year]), CONCATENATEX(DISTINCT('Table'[Year]),'Table'[Year],"&"),"All")

     

    Also please find the pbix as attached.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi ICRdatalover ,

 

Pleae check my sample as below. Here I created a measure to display the values we seleted in the slicer.

 

Measure = IF(ISFILTERED('Table'[Year]), CONCATENATEX(DISTINCT('Table'[Year]),'Table'[Year],"&"),"All")

 

Also please find the pbix as attached.

 

Regards,

Frank

  • ICRdatalover's avatar
    ICRdatalover
    Advocate I
    7 years ago

    Hi v-frfei-msft,

    Thanks for the fast reply.

     

    It is exactly what I was looking for. Im so grateful!

     

    Kind regards,

    ICR