Color Expression for 2 Measures in Bar Chart

Anonymous — Mon, 18 Apr 2016 18:22:45 GMT

Hi,

I am creating a bar chart that compares 4 categories' current and previous scores. I would like the current score for each category to be a different color and all previous scores to be grey. However, I am having trouble using an IF statement since the score calculations require a set analysis. The formulas for current and previous scores are the following:

Current Score

(sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date))"}>}[Points_Earned])

/sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date))"}>}[Points_Possible]))

Previous Score

(sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date,2))"}>}[Points_Earned])

/sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date,2))"}>}[Points_Possible]))

Thanks,

DJE

Re: Color Expression for 2 Measures in Bar Chart

Tue, 19 Apr 2016 05:03:26 GMT

Please share your model, I cant propose a solution without it

topic Color Expression for 2 Measures in Bar Chart in App Development

Color Expression for 2 Measures in Bar Chart

Re: Color Expression for 2 Measures in Bar Chart