Forum Discussion
Line graph with multiple measures having userelationship gives incorrect values
Hi Community,
I am stuck on a graph that doesn't show correct values for measures having userelatationship. Following is a snapshot of the report: On the graph there are incorrect values for the measure 'Services attended'. For example: Consider Nov2020, value of services attended =1 on the graph, but if I pull the values of the measure 'Services attended' for Nov2020 on a card, the value is correct (2). Measure 'Cases_opened has correct values.
Expected values on the graph for 'Services attended' measure:
Also, if you can help me figure out the 'blank' in Month_year will be great.
Here is my pbi file: https://1drv.ms/u/s!Ag919_pO_UKrgQpvUDEhflhKY2xC?e=egMsPL
Many thanks in advance!
5 Replies
- Ashish_Mathur
Super User
Hi,
It will help if you explain the business question, explain the data and show the expected result. Show the expected result in a simple table. Once we get the data in a table visual, we can always build any viz from it.
Ashish_Mathur I have updated my post. You can see the data in tabular fom in the atteched pbi file.
- Ashish_Mathur
There is no table in the PowerBI Desktop file.