Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to add average line to measure bar chart

Hi, 

Need help to add an average line to bar chart.

These measures are calculated through CALCULATE and COUNT with FILTER, etc.

C1.PNG

I want to show them in bar chart with and an average line shows across the bars. Like below:

C2.PNG

However, when I use Line and Staked Column Chart and put the TEST to the Line Values, it shows below. Can someone suggest a way to solve.

C4.PNG

 

Thanks in advance.

1 ACCEPTED SOLUTION
MarkS
Resolver IV
Resolver IV

HI @Anonymous,

On the analytics tab of the clustered column visualization you can choose to add an average line.  Select the measure that you want to average from the dropdown for the measure.

Community 12-21-2017.PNG

View solution in original post

4 REPLIES 4
MarkS
Resolver IV
Resolver IV

HI @Anonymous,

On the analytics tab of the clustered column visualization you can choose to add an average line.  Select the measure that you want to average from the dropdown for the measure.

Community 12-21-2017.PNG

Shelley
Continued Contributor
Continued Contributor

This is awesome! THANK YOU! I couldn't get my measure to work. This gives me what I was looking for. Hopefully, my customers agree.

 

Anonymous
Not applicable

Is there a way to do this but on a horizontal bar chart?
v-shex-msft
Community Support
Community Support

HI @Anonymous,

 

It will be help if you share some sample data.

BTW, if your percentage value is from measure, I don't think you can direct use other measure to calculate average on it.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.