Forum Discussion
How to filter KPI Dyanamicaly
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
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 databasehttps://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
7 Replies
- SamanthaPuaXY
Helper II
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?
I mean When I chanage Parameter Value KPI value should replicate relavant value
v-sdhruvCommunity Support
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 databasehttps://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.
ThanksThank you for your input .
- 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
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
