Forum Discussion

Jane689's avatar
Jane689
Helper I
3 years ago

Dynamic axes values using slicer

Hi,

 

i have a table A which has column - fisc_qtr and Table B which includes column - oppurtunity_qtr .

 

I have used fisc_qtr in one of my visual as x-axis and oppurtunity_qtr as slicer.

 

i want fisc_qtr to show only values FY22Q2,FY22Q3,FY22Q4,FY23Q1 if i select FY23Q1 in oppurtunity_qtr slicer..

similary if i select FY22Q4 in oppurtunity_qtr slicer than fisc_qtr to show only values FY22Q2,FY22Q3,FY22Q4...

 

Let me know how can i achieve this

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Jane689 ,

     

    Firstly, please make sure whether there is an active relationship between Table A and Table B. If there is an active relationship between Table A and Table B, when you select "FY23Q1" in oppurtunity_qtr slicer, fisc_qtr axis will only show "FY23Q1" due to the relationship.

    Here I suggest you to create an unrelated qtr table or unactive the relationship between Table A and Table B. Then create a measure to filter the visual.

    Measure = 
VAR _SELECTQTR = SELECTEDVALUE('Table B'[oppurtunity_qtr])
RETURN
IF(MAX('Table A'[fisc_qtr]) <= _SELECTQTR,1,0)

    Add this measure into visual level filter and set it to show items when value =1.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Jane689's avatar
    Jane689
    Helper I
    3 years ago

    Hey i tried above solution but its giving weird results ... some of rows are missing after using this measure