Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 x axis into only week level (Week Number only) with week over week variation of these three measures

 

2 : If i click mom from the slicer i need to visualise this chart x axis should be in month level only (not week level)
and values should be variation of current month vs previous  month of each measures



Kindly help to achiev this logic , please reply have any queries

Thanks 
Allen

3 Replies

  • nchr's avatar
    nchr
    Frequent Visitor
    3 years ago

    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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hai nchr 

    Apologies here I am not able to find the option to upload pbix, can you show one demo which you mentioned with any dummy data 

    It will be very good