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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
biwessel
Frequent Visitor

How to show line for specific filtered product and line for all products in the same Trend Chart

 

I am new to Power BI and am trying to build a trend chart showing  the %  for one store in specific (filtered) and % of of all our stores combined (no filter applied). Can I show these in one trend chart?

 

Below is an example including only the one store in specific. I am trying to figure out how to add to the same chart an additional line with all stores combined. 

 

Thanks in advance for the help!

Bianca

Power BI Question.png

 

4 REPLIES 4
Anonymous
Not applicable

This can probably be acheived using the ALL function. https://docs.microsoft.com/en-us/dax/all-function-dax

 

So maybe one measure for the specific store CALCULATE(,FILTER()) and then another measure for all of the stores CALCULATE(,ALL())

 

Do you have a little more information about the current measure/value/data?

Thanks a lot for the help! I had to do a few extra steps, but this put me in the right direction!

Anonymous
Not applicable

@Anonymous 

I have a similar question but more so for a scatter chart.

Any idea if it can be done for a scatter chart?

 

Regards

Anonymous
Not applicable

I have not had a use case for a scatter yet so I am not familiar enough to even make a guess. Good luck!

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors