Forum Discussion

ajay_gajree's avatar
ajay_gajree
Icon for Helper I rankHelper I
7 years ago

Funnel Chart Set Axis to Min and Max Values in the Data Set.

Hi All

I have created a Funnel Chart that has Values to 12 on the Axis.

 

I have a filter at the top of the report page where on selections that have no values higher than say 10, then 11 and 12 on the axis disappear.

 

What I want to for the Axis to show 1 to 12 regardless of what the filter does.

 

Cannot see a setting for this.

 

Any help appreciated!

 

Need Help

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi ajay_gajree ,

    You could try to edit interactions so that the funnel chart is not effected by the filter.

    Format > Edit interaction > Choose the slicer visual > Click none in funnel chart.

     

    Best Regards,

    Xue Ding

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

    • ajay_gajree's avatar
      ajay_gajree
      Icon for Helper I rankHelper I
      7 years ago

      Hi

       

      No that isn't what I meant, I want the chart to filter by any of the selections, I just don't want the axis to dynamically change, I want to keep the min and max values of the whole population on the chart and not have it dynamically change to the min and max of the filtered population.

       

      Any thoughts?