Forum Discussion
How to replicate Parameters (tableau) in Power BI?
This is the parameter created in Tableau and I want to create something similar in Power BI, as this parameter is then used to calculate a field called PLAN as below:
What is the best way I can achieve this in Power BI? I want to use this field "Plan" (sum) as my column value.
I referred this youtube video and I created a reference table with the values I wanted and then wrote a measure to connect the main data to this reference table.
Here is the link for anyone who wants to do something similar:
https://www.youtube.com/watch?v=i6OvysJ_SIg
2 Replies
- lbendlin
Super User
You can create the same type of parameter in Power Query. If you want to use it in DAX you either need to convert it from an expression to a partition, or create a reference table instead.
I referred this youtube video and I created a reference table with the values I wanted and then wrote a measure to connect the main data to this reference table.
Here is the link for anyone who wants to do something similar:
https://www.youtube.com/watch?v=i6OvysJ_SIg
