Forum Discussion

DataSheet's avatar
DataSheet
New Member
3 years ago

Small multiples x axis average for each chart

Hello,

I have created a clustered chart multiples where x axis is duration of projects phases shown as a histogram. Now, I have written a measure to show 80th percentile of the duration. But when I add the measure to the x-axis constant line, it shows the same values for each small multiple, which is wrong. Is there a way to show the 80th percentile, and possibly average for each individual chart? 

Thank you.

Picture of current situation down below. Black line is 80th percentile, average is blue.

 

 

1 Reply

  • In small multiples you can have non-synchronized Y axes but not X axes.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com