Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I hope someone can help
I am trying to write a measure which sums the total costs in a column and plot it as a horizontal target line on the graph. The bit I cannot get to work is making it consistant across all months (the X axis) rather than variable depending on the month.
I have had a look at using the constant line feature, however I need it to by dynamic and change as more costs are added to the source data
Your help would be greatly appreciated
Matt
Solved! Go to Solution.
Hi @Matt22365 ,
Try this:
1. Create a Measure like so:
Sum Measure = SUMX ( ALLSELECTED ( 'Table' ), 'Table'[Value] )
2. Create a Line and Stacked column chart. And I opened "Align zeros".
Then, the Sum Measure will change as the underlying data changes.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Matt22365 ,
Try this:
1. Create a Measure like so:
Sum Measure = SUMX ( ALLSELECTED ( 'Table' ), 'Table'[Value] )
2. Create a Line and Stacked column chart. And I opened "Align zeros".
Then, the Sum Measure will change as the underlying data changes.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Thank you, that worked great
Matt
Use ALL or ALLEXCEPT or REMOVEFILTERS to exclude your month/date as a filter.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |