How to filter KPI Dyanamicaly

[milindwasekar]

In my current dash board I am showing two KPI Total Revenue and Prev Month Revenue as shown below in which year filter 2022 selected. 

In the Chart I had created field parameters

Parameter = {

    ("ProductColor", NAMEOF('Product Lookup'[ProductColor]), 0),

    ("ProductName", NAMEOF('Product Lookup'[ProductName]), 1),

    ("Country", NAMEOF('Territory Lookup'[Country]), 2),

    ("SubcategoryName", NAMEOF('Product Subcategories Lookup'[SubcategoryName]), 3)

I want to create measure of Total Revenue and Prev Month Revenue such that when I select any of the field parameter  from drop down KPI should dynamically show the value of relavant paremater if not selected any parameter it should show existing values

How to do this 

My data model is appearing like this .I used AdventureWorks Data base

[v-sdhruv]

Hi @milindwasekar ,
I hope your issue was addressed.
If you were able to resolve the issue, pleas Acccept it as a solution or give Kudos so that other users can benefit from it.
Thank You

[v-sdhruv]

Hi @milindwasekar ,
I hope your issue was addressed.
If you were able to resolve the issue, pleas Acccept it as a solution or give Kudos so that other users can benefit from it.
Thank You

[v-sdhruv]

Hi @milindwasekar ,

I hope you were able to resolve the issue.
Please consider marking Accept as solution or give kudos to the post that helped you so that other users can benefit from it.
If you still need any help, feel free to reach out to us.

Thanks

[v-sdhruv · Accepted solution]

Hi @mwasekaar ,

You can use the field parameters you just created into single slicer and when you select any parameter of your choice it will reflect Total revenue / Previous revenue accordingly.
An example of field parameter is shown here on Adventure Works database

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

Hope this helps!
If you found this solution useful, please accept it as solution or give Kudo so that other users can also benefit from it.

Thanks

[mwasekaar]

Thank you for your input . 

[mwasekaar]

I mean When I chanage Parameter Value  KPI value should replicate relavant value

[SamanthaPuaXY]

Hi @milindwasekar , by right the data is already showing data based on your selected filter. However, if not selecting any parameter, what do you mean by existing values?