Line graph with correct value with slicer

Question

Hi I have a table like this:NameDateTypeMilesHoursMiles Per HourAAA11/1/2021Actual895&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.80AAA11/2/2021Actual1104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27.50AAA11/3/2021Actual854&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21.25BBB11/1/2021Actual1224&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30.50BBB11/2/2021Actual814&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20.25BBB11/3/2021Actual977&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13.86CCC11/1/2021Actual1135&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22.60CCC11/2/2021Actual987&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14.00CCC11/3/2021Actual1267&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18.00&nbsp;Miles Per Hour is Calculated by Miles/ HourI'm creating a trend line, with Date on the X axis and Miles Per Hour on the Y axis with Name on the slicerYou see that the problem comes when I unclick all the slicer, I want the "Miles Per Hour" to be the total "Miles" across all "Names" divided by the total "Hours" across all "Names" within each "Date"But here, it is adding up all the "Miles Per Hour" for each "Name" in that "Date".&nbsp;Does anyone know how to solve this?&nbsp;

v-easonf-msft · Answer

Hi,&nbsp;Anonymous&nbsp;
How did you create the trend line, add auxiliary lines in the&nbsp;‘Analyze panel’ or create an additional measure?
Please share your sample file on the cloud for further research.
&nbsp;
Best Regards,Community Support Team _ Eason

anonymous · Answer

Hi I'm sorry, du you know how to share the file?Cause I cna't find where

v-easonf-msft · Answer

Hi,&nbsp;Anonymous&nbsp;
You can upload you sample file to cloud storage and then share the link.
&nbsp;
Best Regards,Community Support Team _ Eason

anonymous · Answer

https://dpdhl-my.sharepoint.com/:u:/r/personal/emily_tsai_dhl_com/Documents/powerBI/Example.pbit?csf=1&amp;web=1&amp;e=18Z2sx&nbsp;

anonymous · Answer

let me know wether this works

Forum Discussion

Line graph with correct value with slicer

6 Replies

Related content

Correcting Data

Dax correction

Dax Formula correction help

Graph not sorting correct

Slicer not showing correct data

Name	Date	Type	Miles	Hours	Miles Per Hour
AAA	11/1/2021	Actual	89	5	17.80
AAA	11/2/2021	Actual	110	4	27.50
AAA	11/3/2021	Actual	85	4	21.25
BBB	11/1/2021	Actual	122	4	30.50
BBB	11/2/2021	Actual	81	4	20.25
BBB	11/3/2021	Actual	97	7	13.86
CCC	11/1/2021	Actual	113	5	22.60
CCC	11/2/2021	Actual	98	7	14.00
CCC	11/3/2021	Actual	126	7	18.00