Forum Discussion
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:
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
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
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
Hi, I'll look into this and get back to you.... sounds like it maybe what I'm after..
4 Replies
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
Hi, I'll look into this and get back to you.... sounds like it maybe what I'm after..
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
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.