DAX

[colourfullife]

Please find attached file

I want to analyse the plan vs actual progress by choosing many options which are in slicers.

For example, choosing discipline piping > deck MDK > module P03 like that..

Whenever i choose any slicer, the graph's value get incorrect.?

I am pretty sure i am missing things that i have no clue.

Basically i want to see the plan lines 0%-100% whichever slicers i choose with progressed lines if there is progress.

Thanks,!

[v-jiascu-msft]

Hi @colourfullife,

What do these lines mean? They are from the calculated columns that are just like normal columns. If you apply some slicers, the lines could start from other values other than 0. 

BTW, don't share sensitive data here.

Best Regards,