The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi guys,
I am trying to create a financial report table. Each group has its own filters ( like color, size, location, price) and filter numbers differ in each group. I need to show by MTD, QTD, YTD.
How can I create it? What would you advice?
Now, I am using conditional column but numbers are not correct for one group.
@Zafar06 , I think calculation groups can help
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
you can now create calculation group in desktop
Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU