Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I have the following table created using a slicer selection that allows me to add or remove columns.
The approach used is described here:
However, The Sales values are not summed up when I remove Country and leave only Region. See the result below:
As report user, I would expect to have only 1 row for each region and the total sales for that region. Is that possible?
Thank you very much in advance for your support!!
Best regards
Solved! Go to Solution.
@atrigo , You still have the index column, that is unique for each row.
Thanks a lot @amitchandak and @v-yetao1-msft . I will keep investigating for an alternative solution to attend the requirement to add or remove columns dynamically, with an automatic aggregation of values.
Best regards
Hi @atrigo
Since your index is a unique value, there is no way to achieve only one row for each area you said.
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@atrigo , You still have the index column, that is unique for each row.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |