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,
I currently have this visual.
But I would like the columns grouped in the below manner.
Thanks in advance!
Hi @ddayanand ,
You could create an allocation table to do this.Otherwise, you can't put measure as columns in Power BI. You could put it in Values, but for it to work for the screenshot you've posted, you'd have to create a separate measure for each SUM date(for example, 11-8 sum of actual,11-15 sum of actual, etc.) .
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ddayanand , measure above dimension /column is not possible to design
these are few work around
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795