Doughnut chart small multiples alternative

[kinkate18nic]

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

[amitchandak · Accepted solution]

@kinkate18nic , create these 4 measures and try them as visual level filter

[kinkate18nic]

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

[kinkate18nic]

Also, missed to mention am working on a PowerBI dataset.