Forum Discussion
Treemap and Card
Hi, I have a question regarding Treemap and Card when they are connnected.
when I click one block in the Treemap, a corresponding value will be displayed in the Card. When nothing in the Treemap is selected, it will show the sum of the values in the Card data. But I'd like to show another value in the Card data when nothing is selected in the Treemap.
Thank you in advance.
You can use isfiltered or hasonevalue. or isinscope depend on your formula need what you want to display
Please refer.
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Provide more information, to help further.
3 Replies
You can use isfiltered or hasonevalue. or isinscope depend on your formula need what you want to display
Please refer.
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Provide more information, to help further.
thank you!
PLease try to use HASONEFILTER or ISFILTERED in the measure you are using in the card.
it should work 🙂
