SWITCH between PERCENTAGE and ABSOLUTE VALUES in one visual I Calculation Groups in Power BI

In this video I show you how to create buttons to switch between % and absolute values.
Learn more about calculation groups in Power Bi.

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00​ Intro
0:27 Getting Ready: Visual and Tabular Editor
1:43 Adding a calculation group with calculation items
4:20 Applying the calculation group
5:38 Formatting expressions in calculation groups
6:57 Show slicer with buttons
8:06 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[simonloughnane]

What a great practical example of using calculation groups, and also one that is not too intimidating for people (like me) who are new to them. I must commend you on the editing and production of your videos, they are so slick. No doubt a lot of work goes into achieving that, thank you.

[xodrinker]

Smooth. Need this early next week. Perfect timing Bas. Thx.

[DilbagSingh-vfgv]

hello, im new into data analyst. firstly your videos are wonderful, to the points and explains everything. every now and then i goes to your channel to clear my doubts or learn something new. secondly you mentioned two approachs to percentage problem and expalined only on, can you put light on another way too, as tabular editor is paid software and i cannot right now buy it.

[BIGorilla]

Great video ! The part on the format expression is very effective to get a very flexible report. The calculation groups also are a real solution to keep the performance snappy. Looking forward to your next video!

[isidrebague]

Very good video, great result and effective. Thanks for sharing

[fraggle]

Great vid that shows exactly what I was wanting to do... only downside is that after I bring in the calculation group any field I add to a table will only show distinct values and nothing else. it completely breaks the pbix. Can't find how to resolve it either.

[azarmeeza]

You are doing a great Job Buddy Keep going strong..

[ricardopinxt]

Helemaal geweldig weer 😁.
Very well explained, easy and fun to follow.
And indeed also a nice introducer to Tabular Editor for me!
Thanks.

[gennadypronin]

I like your content submission! That's cool!
A year ago I tried to solve the problem with displaying percentage and number in a radio button, but I still couldn't find how to do it.
Thanks for the solution!

[supreethalahari.sreeram]

Great video, can you please help me how to create a switch from numbers to percentage without using tabula..

[artemburov]

Thanks, Bas, for abother great video. Very practical and useful.

[lucianozx]

Hi, Thanks for the teachings, in a didactic and simple way, you are the greatest.
Can you help me? I have two Bar Charts and one Card, and all working ok, as your example (% or absolute in all of them), can you please tell me how to exclude Card, so that it always shows the absolute value only, and never switch to %?

[panpan]

Thanks so much! One question wants to seek your help, when I switch to "% of Total", why it shows the percentage of the total number instead of percentage of current month?

[a.]

Is this method faster than just bookmarking two different graphs with their own measures? (e.g., hide/unhide graph base on user selection)

[ikenigs]

Amazing video man! Super simple and super useful!

[MoinKhan-]

Wow its amazing bass. but I have a question My Organization not allowed tabluar editor.
how can I create this measure in power BI? I think now there should be updates in power BI itself because this video is 3 years old.

[pedropradocarvalho]

Very good video, I wonder if we can adjust other format settings, like from horizontal to vertical orientation on the datalabels for the visual, for instance.

[Dritty]

Thanks Bas. Really clear explanation. I have a question/problem after I implemented this solution. I cannot add/dragg a (numeric) column to the 'Values' of a visual. I can only add/dragg a measure. So I have to make a measure of every column I want to visualize. Is there a way to fix this?

[djbastoni_au]

Thanks for this. Well explained and I think I can implement after downloading tabular editor (been watning to unleash its power for a while now).

[EricaDyson]

Very nice. Great explanation. Keep going!