Forum Discussion
all measure
Hi there,
I need a column chart to show accident by year, and a multi-row card to show the number of selected year.
Please advise how to write the measure. Thank you
Here is my data
Hi, Anonymous ;
You don't have to write measure, as follows:
1.create a clustered column chart.
2.create cards;
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous , You can use year from date hierarchy
or
year = year([Date])
Use that on axis
Catrgory legend
and Sum(Table[Number])+0 , measure on values
Multi-row car you should build on category , it should filter selected year
if you want slicer not to filter stop interactions
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
You don't have to write measure, as follows:
1.create a clustered column chart.
2.create cards;
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
