Forum Discussion
Doughnut chart small multiples alternative
Hello,
Since we dont have small multiples for doughnut chart, what is the best alternative. I want to display my data for last four months in four charts at anypoint when a user access the report, it should dynamically take last 4 months as per current month and show in those four charts, E.g if report is opened today, it should July, June, May, April data in four doughnut charts. Am accessing data using directquery, so creating new tables is not an option.
My data is basically list causes and count of tickets of those cause on a daily basis.
Any guidance is highly appreciated.
Thanks
kinkate18nic , create these 4 measures and try them as visual level filter
3 Replies
- amitchandakSuper User
kinkate18nic , create these 4 measures and try them as visual level filter
- kinkate18nicFrequent Visitor
Hi, thanks for the reply.
You mean to say create 4 measures for previous four months date-ranges?If so, little help there, I can write simple DAX can't figure out this one.
Thanks
- kinkate18nicFrequent Visitor
Also, missed to mention am working on a PowerBI dataset.