Unable to show line graph without the aggregated values

[Anonymous]

Whenever I filter down the values it gives me the correct value but as i remove the filters it gives me aggregated value. I'm not able to use don't summarize option as well. Is there a way to create a line graph wthout aggregated values

[parry2k]

@Anonymous glad to hear. Doesn't matter, but I think by mistake you accepted your reply as a solution. I would recommend accepting a solution that gets it to worked so that others can take help from it. If you did something to make it work, put that as a reply and then accept it as a solution. 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@Anonymous if you put frac on legend it will not combine those together, no idea what you are doing. share pbix file if you need further help, remove sensitive information before sharing

[parry2k]

@Anonymous I see, put Fracs on the legend so that it keeps these Fracs  separate.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous · Accepted solution]

Actually it worked! Thank you for the help

[Anonymous]

This doesn't work, since there;s data for different fracs on same date it's combining everything together by date

[parry2k]

@Anonymous you are providing very little information, what is on x-axis for visual? What measure you are using to show as values? if you can provide more details, it will save a lot of time.

[Anonymous]

I'm using x axis as time and in values I'm using % dollar column. These are the only columns I'm using. And I'm trying to filter based on Frac names. % dollar is calculated based on two other columns but this calculation is done in the data source itself nothing on power bi side. 

[parry2k]

@Anonymous no, you cannot use non-summarized values, paste sample data and expected output what you are trying to achieve, there might be another way to resolve it.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

so I have been using runtime and % dollar in the line graph and I have a slicer for fracs. So when I filter it based on fracs i see the right values but if the slicer is selected to All it gives me aggregated value which is wrong.