Multiple card visuals with measures based on 2 KPIs

[sarahfreedom]

Hello,

I am working on a dashboard and I am facing two challanges as I am a beginner with PowerBI:

1. I want to dispay several card visuals based on calculations for two KPIs. For example KPI1 could be either Z1;Z2;Z3;Z4 and KPI2: W1;W2;W3;W4. In order to do that I created multiple measures which I then added to the card visuals. My question is if instead I should be creating one measure that could then be filtered individually on the card?

2. The results of this card visuals would represent a number of customers that fall under the above mentioned KPIs. Is there a way to add a button below/above the card that would allow users to quickly navigate to the list of customer that are included in any of the calculations instead of having to download it in a file?

[Idrissshatila · Accepted solution]

Hello @sarahfreedom,

For question one, you could group the KPI1's measures in a field parameter and the user could switch between each measure with a slicer.

refer to this document for instructions https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

regarding your second question, I did't really get your point, but if you want to drill through a measure value in a card  then it's not possible.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin