Forum Discussion
Static Reference Line Across the population
Hi,
I'm trying to get a static reference line based off a measure, calculating 75%.
When I put this into my clustered column chart, it populates the 75% within each month. However I'd like this to have a static line, with the 75% of all items, therefore bringing the reference line straight across and higher than the column bars.
Is this possible?
Hi, Anonymous
Thanks for the reply from samratpbi , please allow me to provide another insight
Based on your information, I create a sample table:You can create a measure to act as a static guide, like the one below, try the following DAX expression:
TotalMeasure75Percent = SUMX(ALL('Table'), 'Table'[Sales]) * 0.75How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi,
if your 75% is constant, then you may add a Reference Line from visual property and make a Constant line with your value.
If this resolves your problem, then please mark it as solution, Thanks!
Hi, Anonymous
Thanks for the reply from samratpbi , please allow me to provide another insight
Based on your information, I create a sample table:You can create a measure to act as a static guide, like the one below, try the following DAX expression:
TotalMeasure75Percent = SUMX(ALL('Table'), 'Table'[Sales]) * 0.75How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
