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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

How to see the total sales while easily be able to see sales per product group

Hi all,

 

I have a simple line graph showing the total sales over time (first picture).

Using a column, every sale is categolrized as one of four product groups.

My colleagues want to easily see the composition of total sales between the product groups (but seeing total sales is the most important). 

So I want to make something like when you hold your mouse on a data point of the total sales, that you see the total sales for each product group.

If I add the product group to the legend, I see that every product group has an individual line in the graph and I can't see the total anymore (which is the most important to see) --> second picture.

 

Does anyone have ideas how I can visualise the total sales while making it easy to see the sales per product group over time. I also tried the stacked charts but these make it hard to easily see the total of all product groups as well. 

commodity_check_0-1620811678876.png

commodity_check_1-1620811815721.png

 

 

 

 

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , based on what I got

 

Total sales  = calculate([sales], allselected(Table))

 

Total sales  product wise= calculate([sales], filter(allselected(Table) , Table[product] = max( Table[product]))

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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