The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
Also, missed to mention am working on a PowerBI dataset.