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

[ajay_gajree]

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!

[v-xuding-msft]

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]

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?