Forum Discussion
Anonymous
3 years agoNot applicable
Dynamic Axis Power bi
Hi Here i am facing one Challenge to create Dynamic X asis Here i have WOW & MOM slicer and i have three measures, Expecting output: 1 : if i click wow i need to visualise this chart...
nchr
3 years agoFrequent Visitor
Assuming you have the measures available, what you need can be implemented by using Field Parameters.
So, without knowing anything else about your data model, I will suggest the most basic approach:
- Create a Field Parameter (FP) with the Week and the Month from your Calendar Table. Check the Add Slicer option to have the slicer generated.
- Create a measure that returns WoW values when Weeks are selected and MoM values when Months are selected. It might be tricky to get the selected value on a Field Parameter, so maybe you can use ISINSCOPE() for that.
- in your visual, put FP in the X-Axis and the measure in the Y-Axis (or Value?) slot.
Now, the visual will display content according to your selection on the Field Parameter,