Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
one action has several situations differing on date like in the image below
i need to make a pie chart that shows only the latest situation for each action
i managed to make a measure showing me this, but i cannot put the measure on the legend of the pie chart.
any suggestions?
here's the measure i made
maxx(topn(1,'public fato_acao',CALCULATE(max('public fato_acao'[dt_status_acao])),desc),'public fato_acao'[id_situacao_acao])
@rafaelarbl , Not very clear, but dt_status_acao as legend and the measure above in pie visual
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |