Forum Discussion
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 card will show total sales of all years and the % YoY card will still have a value (= (total 'Sales this year' measure-total 'Sales LY' measure) / total 'Sales LY' measure), which would be meaningless.
I could change the Year slicer to single-select to solve this problem, however I have a line chart on this page, which can drill up to compare all years (only possible when all years are selected in the slicer) or drill down to see quarter/month-level. How should I go solve this? Thanks.
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.
2 Replies
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.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.
