Forum Discussion
Is it possible to use a field parameter to segment between two other field parameters?
Is it possible to use a field parameter to segment between two other field parameters?
But with the function of displaying the "values of selected fields" and not just the fields.
Parameter 1 displays three measures that perform monthly analysis.
Parameter 2 displays another 3 (different) measures that perform the quarterly analysis.
I would like to create a main parameter that segments between parameter 1 and parameter 2.
2 Replies
- amitchandak
Super User
SoftgranDdos ,if you have one measure or traditional slicer
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Measure slicer for this one - How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M
else
Create a field parameter with Month and QTR (Axis/Dimension)
Create a slicer with 6 Measures, and then use the selected value code I have given the blog to filter the measure slicer. But remember when you switch from month to qtr, it will not switch measure automatically
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE I solved it by creating a new column within one of the parameters, and in this column I put monthly and quarterly, allowing me to filter just one segment and get it to return the measures I defined.
Then I went to the relationships and connected the parameter that I use to segment the dCalendar table to the Parameter that I created.
And it worked 100%
