Forum Discussion
Utilizing KPI card
I want to be abel to switch between different states within a KPI Card, meaning I want to abel to show Year-over-Year, this week compered to last week, last two weeks compered to the two weeks before that within the same KPI-card. Does anobody have any experiance with that?
Hi, Anonymous
According to your description, you want to switch between different states within a KPI Card.
Do you mean that you want to display KPI visual objects with different dimensions or different calculation logics?
If you want to modify the display of your visuals using slicers etc, here are a few things you can try.
In the first one, we can use the display and hiding of Bookmark to bind the corresponding buttons to achieve visual object display in different situations. For more information, you can refer to :
Switching Visuals using Bookmarks: Power BI Desktop (vivran.in)Second, we can use Field Parameter to implement calculations of different dimensions using slicers.For more information, you can refer to :
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft LearnIf this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi, Anonymous
According to your description, you want to switch between different states within a KPI Card.
Do you mean that you want to display KPI visual objects with different dimensions or different calculation logics?
If you want to modify the display of your visuals using slicers etc, here are a few things you can try.
In the first one, we can use the display and hiding of Bookmark to bind the corresponding buttons to achieve visual object display in different situations. For more information, you can refer to :
Switching Visuals using Bookmarks: Power BI Desktop (vivran.in)Second, we can use Field Parameter to implement calculations of different dimensions using slicers.For more information, you can refer to :
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft LearnIf this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly