Forum Discussion

phuonganhtdinh's avatar
phuonganhtdinh
Icon for Helper I rankHelper I
6 years ago
Solved

Drillup interaction

My report page has a Year slicer (multi-selection), a card displaying current selected year's Sales, and a card showing % Sales change YoY. When no year is selected (slicer says 'All'), the Sales car...
General Comment
Need Help
Tips and Tricks
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi phuonganhtdinh ,

     

    You may create measure to determine if show a message when no selections is made in year slicer, and display the measures in Card visual hover your original Card visuals one by one.

     

    Message measure1 = IF(ISFILTERED(Table1[Year]),SUM(Table1[Sales]), "No Year is selected")

Message measure2 = IF(ISFILTERED(Table1[Year]),[% Sales change YoY], "No Year is selected")

     

    For reference:

    https://community.powerbi.com/t5/Desktop/Stacked-Column-chart/m-p/648754#M311066

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi phuonganhtdinh ,

 

You may create measure to determine if show a message when no selections is made in year slicer, and display the measures in Card visual hover your original Card visuals one by one.

 

Message measure1 = IF(ISFILTERED(Table1[Year]),SUM(Table1[Sales]), "No Year is selected")

Message measure2 = IF(ISFILTERED(Table1[Year]),[% Sales change YoY], "No Year is selected")

 

For reference:

https://community.powerbi.com/t5/Desktop/Stacked-Column-chart/m-p/648754#M311066

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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