Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have created a dropdown in desktop to select the dates and have to automatically compare the avg(score) value of the selected week date with the previous week avg(score) value for both the the cities, here as an example compare(22, 1.5)- 9th Nov and 2nd Nov. Then output should display different new Unicode symbol with colours for different outcomes i.e both are equals, Greater and Lesser.
Date | State | Score |
11/2/2018 | A | 1 |
11/2/2018 | B | 2 |
11/9/2018 | A | 22 |
11/9/2018 | B | 22 |
11/16/2018 | A | -4 |
11/16/2018 | B | -4 |
11/23/2018 | A | 6 |
11/23/2018 | B | 6 |
11/30/2018 | A | 4 |
11/30/2018 | B | 4 |
Could you please help me on how i can achive this?
Thanks in Advance:
Nishanth
Solved! Go to Solution.
Hi @Anonymous
You may check the measures in attached file.Use conditional formatting for the output measure.For further,please refer to Power-BI-Desktop-DAX-Using-Unicode-Arrows-as-Measures-in-a-Tabl.
Output = IF([Selected Avg]>[Previous Avg],UNICHAR(9650),IF([Selected Avg]<[Previous Avg],UNICHAR(9660),"="))
Condition = IF([Selected Avg]>[Previous Avg],1,IF([Selected Avg]<[Previous Avg],2,3))
Regards,
Cherie
Hi @Anonymous
You may check the measures in attached file.Use conditional formatting for the output measure.For further,please refer to Power-BI-Desktop-DAX-Using-Unicode-Arrows-as-Measures-in-a-Tabl.
Output = IF([Selected Avg]>[Previous Avg],UNICHAR(9650),IF([Selected Avg]<[Previous Avg],UNICHAR(9660),"="))
Condition = IF([Selected Avg]>[Previous Avg],1,IF([Selected Avg]<[Previous Avg],2,3))
Regards,
Cherie
for the "symbol" you could create a custom table with a join between your "State" and the code, then show it in a table.
For the colour, you can simply use Conditional Formatting in the cell.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |