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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mgtaylor33
Frequent Visitor

Multiple Values as one single mark on a Line Graph Chart

Hi There, as the Subject says, Data Looks like this...

National    SW         SD           FTD         B4_10        RD        POD        OFD         DOT

                   96.4%   52.84%    97.41%      88.46%  99.49%   99.59%   99.39%    87.23%

Chart:

mgtaylor33_0-1700779577891.png

While I can do this in Excel...   How do I do this in Power BI..   The X Axis in the example are calculated measures in my  pBIX.

 

Any thoughts?  KInd Regards Mike

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@mgtaylor33 , Create a calculation group and use its name on X-axis and measure in values or y-Axis and try

 

Learn Power BI: Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Hi, I'll look into this and get back to you.... sounds like it maybe what I'm after..

 

View solution in original post

4 REPLIES 4
Ritaf1983
Super User
Super User

Hi @mgtaylor33 
As an X-axis is categorical you can't put measures on it, it should be a column.

If your table is horizontal as in the picture you need to unpivot it.

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Hi, Yes that is indeed the problem, but Unpivoting doesn't do the required chart.. as each mark ( dot ), has to be named the 'seperate' mark name. So in my graph image  each point is each measure but on one line chart....  Thanks anyway though.

 

amitchandak
Super User
Super User

@mgtaylor33 , Create a calculation group and use its name on X-axis and measure in values or y-Axis and try

 

Learn Power BI: Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi, I'll look into this and get back to you.... sounds like it maybe what I'm after..

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors