Forum Discussion
Dynamic measure values based on slicer selection
Hi everyone,
I have a spreadsheet with hotel rates and locations as shown below:
I require a measure which can switch between three options from a slicer (Ie: AUD, GBP, USD) using data from another table as shown below:
So for example, if i create an average rate card, when i select different currencies, the figure in the card will adjust depending on the rates in the second table.
Is such a measure possible? If so, how would you go about creating it?
Any help would be much appreciated.
Zina
4 Replies
Hi
Here is a good example on how to do that
https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/
made by GilbertQ
/Erik
HI zina-aziz,
Sure, you can create a measure based on the selected value in slicer. But you should build a relationship between the two tables. Which means there should be some same columns in the two tables and values in one of the column need to be unique.
Please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Regards,
Jimmy Tao
You can create a parameter hosting the options with datatable, no need for relationship with other tables.
Have your measures ready for each option and then use SWITCH and SELECTEDVALUE together and nest your measures inside.This video explains it in two ways thoroughly
Hi,
Here is what you are looking for :
Quentin
