Forum Discussion
Line Graph With Matrix
Hi, I am trying to create a line graph using 2 measures. So the end result should be my line graph and my matrix working together. I have only been able to display one measure working properly. What am i doing wrong?
Hi Nfuentes86
To better assist you, could you please share a screenshot of the current setup where the line visual and matrix are not interacting as expected?
This will help us do a deeper analysis and identify if there’s a filtering, interaction setting, or model issue.Once I have this information (especially the screenshot), I’ll be able to guide you with more targeted steps or corrections.
Appreciate your patience!
11 Replies
- v-aatheequeCommunity Support
Hi Nfuentes86
Thanks for sharing the screenshot!
From what I can see, your matrix visual is displaying multiple measures correctly, but your line chart currently shows only one. If your goal is to have both measures represented in the line chart, we’d be happy to assist further.
To better understand the issue and provide a more accurate solution, we kindly request you to share a sample dataset that fully illustrates your scenario. Please ensure the data:
-
Is provided in a usable format (not as a screenshot),
-
Does not contain any sensitive or confidential information,
-
Focuses only on the relevant part of the issue.
Also, if possible, include the expected output based on the sample data. This will help us provide a solution tailored to your specific needs.
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityLooking forward to your response!
- Nfuentes86Helper I
Monthly Table -6300261-ByHistoricMonth - NF.pbix please use "Duplicate of two visuals".
the goal is for 2 measures to display properly. like this
- v-aatheequeCommunity Support
Hi Nfuentes86 ,
Thanks for sharing the updates.
In the Values field well of the line chart, ensure that both measures are added.
If only one measure is visible, try dragging the second measure into the Secondary Y-axis section to display both lines correctly as below :I’ve created this setup on my end, and the output matches the expected result, as shown below :
Hop this helps!!
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
Regards,
Atheeq.
-