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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.