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
Jo_Chrq
Helper I
Helper I

Add Average on Bar Chart

Hi All,

Using a Store table and a Sales table, I have a bar chart with income and margin per store on a bar chart.

I wonder if it's possible to add average values, as if it was a store as well?

Something like that in Excel:

Jo_Chrq_0-1674486958428.png

 

Many thanks in advance

Jo

 

1 REPLY 1
Mikelytics
Resident Rockstar
Resident Rockstar

Hi @Jo_Chrq 

 

Can you please try as a genertal measure this something like:

Average over column=
CACULATE
   AVERAGEX(
      VALUES(Table[Column]),
      [your base measure]
   ),
   ALL(Table[Column])
)

 

for table[column] use your strore column.

 

To make sure that you have the average as a separate bar in the end you would need to add the "average" value in the dimension table with a dummy key or something. Then it might be possible with the following appraoch:

 

with seperate abr chart =
IF(SELECTEDVALUE(Table[Column])="Average"),
   CACULATE
      AVERAGEX(
         VALUES(Table[Column]),
         [your base measure]
      ),
      ALL(Table[Column])
   )
   ,[your base measure]
)

 

without knowing the complete data model it is hard to give a answer on point but I hope it helps you.

 

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

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.