Forum Discussion
Filed Parameter Slicers Synchronization
Hi All,
I have two field parameters
[Column Y ] = {
("Forecast QTY", NAMEOF('_Measures'[Forecast QTY]), 0,"A"),
("In Range", NAMEOF('_Measures'[In Range]), 1,"B"),
("In Stock", NAMEOF('_Measures'[In Range]), 2,"C") }
[Line Y ] = {
("Sales", NAMEOF('_Measures'[Forecast QTY]), 0,"A"),
("Profit", NAMEOF('_Measures'[In Range]), 1,"B"),
("Loss", NAMEOF('_Measures'[In Range]), 2,"C") }
I am using Column Y slicer with A,B,C values and Line Y slicer with A,B,C values.But I want to show the Column Y slicer to the user and wanted to hide Line Y slicer.
I am using line and stacked column chart and Column Y taken on Column Y axis of visual and Line Y taken on Line Y axis of visual. I want them dynamically in my visual when I select any value in Column Y slicer on the page. If I select A on Column Y slicer then I am expecting A should get selected on Line Y slicer then only I can see the expected values on the visual. Is it possible?
Scenario:
If I select A in Column Y slicer then I want to see the below attributes in visual
X-axis: Default one
Column Y axis: Forecast Qty
Line Y axis: Sales
I select B in Column Y slicer
X-axis: Default one
Column Y axis: In Range
Line Y axis: Profit
I select C in Column Y slicer
X-axis: Default one
Column Y axis: In Stock
Line Y axis: Loss.
I can achieve the above scenario using measure with switch condition but I wanted to use field parameters here and I wanted to see the column and line Y axis names should get changed along with the legend names.
Anonymous
- Anonymous1 year ago
I could able to do that using Advanced options on the sync slicers section. Thank you
2 Replies
- AnonymousNot applicable
I could able to do that using Advanced options on the sync slicers section. Thank you
- AnonymousNot applicable
Hi Anonymous ,
Could you please provide example data or sample files? And what you expect the output to be. There is sensitive data that can be removed in advance. How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.