Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am using matric to visualse sales value and % monthly, as of now it looks like below:
Is there a way to get the Sales % for each month first then followed by each month sales amount after that? I dont want to alternate between sales and % like the current one.
Like: %%%%----SalesSalesSales
Thanks
@kinkate18nic , Calculation Group can help, refer to my video for that
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Thanks for reply,
Am using direct query, is there an alterntive in this case?
Kind regards
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |