Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys!
So i got really fed up with clicking on every single value to set it to "SUM" when creating my table. I found out there should be a "default summarization" option in the MODELING card. Yet there is none (and also some of other features are missing). Why is this?
Thanks for answers 🙂
Solved! Go to Solution.
@Anonymous
you can go to the Model view, Ctrl+ click on all demanded fields and change its default summarization
Hi @Anonymous ,
It's not missing, it's just moved to a new area.
I see that you are using the new ribbon in Power BI.
Click on your column in FIELDS pane, you will see something like this in the ribbon:
From here you can modify default summarisation.
Thanks,
Pragati
Oh okay! So I do have to define the default summarization for each value and then it will work on?... Well that doesnt really solve my situation. As i have lets say 40 values, that I will use only once. I would love to mark them all (e.g. shift+click) and then change the summarization.
@Anonymous
you can go to the Model view, Ctrl+ click on all demanded fields and change its default summarization
Yesss!
Thank you very much 🙂 This community is indeed very helpful. Have a good day guys! 🙂
@Anonymous
default summarization option is available on Field level. Pick your field in the right pane and go to Column tools or Measure tools ribbon
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |