Change Measure using a Slicer

Рет қаралды 58,306

4 жыл бұрын

One of the most common questions that I get is, how can I change measures using a slicer? In this video I’ll exactly show how can you do that in Power BI.
Download File - www.goodly.co.in/change-measu...
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog

Пікірлер: 115

@ameedazfar2023 3 жыл бұрын

Hi, just want to say this out loud. You truly make working with DAX easy! Thanks for showing the step by step iteration of the complete process. :)

@shubhamsinha866 2 жыл бұрын

Completely agree

@mohitmanwani5298 4 жыл бұрын

As always, best crip and clear explanation... Cheers..Way to go.. A true asset for Data Community

@rakeshc8502 3 ай бұрын

Wow, I have been searching for this calculation for the last 2 weeks or so...finally found it; thank you!

@chitwinder 3 жыл бұрын

You resolved the big problem.Thank you!

@SethChristianWells 7 ай бұрын

Dude, thank you! Easy to understand and got what I needed!

@pravinshingadia7337 4 жыл бұрын

Excellent video again. I love that you get straight to the point! Keep it up.

@GoodlyChandeep 4 жыл бұрын

Glad you found it helpful

@branzo79 2 жыл бұрын

this is excellent. you can dynamically change your title (if you add one to the table) by pointing at your 'select a calculation' measure in the title format panel. it works for me.

@bruckworkie8902 2 жыл бұрын

That's great. Would you elaborate on how you were able to change the title dynamically?

@jermainecameron6209 2 ай бұрын

Exactly what I needed, thank you!!

@grytskokonstantin1272 14 күн бұрын

God bless you. Thank you so much.

@nikithahiremath8658 Жыл бұрын

Thanks for this Video its soo simple and clear instructions.

@ariffkmy4235 3 жыл бұрын

thank you for the tutorial!!

@scottwilliams6741 3 жыл бұрын

This is a great post! Thank you very much!!

@fabianjenkins876 11 ай бұрын

Worked perfectly, Thank you!

@kennethstephani692 3 жыл бұрын

Outstanding video!!

@jomishmathew1447 3 жыл бұрын

Excellent as always...👍

@Laxmanmane007 4 жыл бұрын

really awesome ,something new one and very useful.. thanks for this amazing video..

@wizkidcyclist9968 2 жыл бұрын

thanks, this was very well explained.

@emilmubarakshin49 11 ай бұрын

Amazing Chandeep you’ve had video for these waaaaay before the field parameters were introduced to powerBi 👍👍👍😍😎🤗😁

@mcsquarewolf9557 7 ай бұрын

Great video, very very helpful

@dblack777 2 жыл бұрын

Excellent video, sir!

@massimocolaceci 3 жыл бұрын

Excellent. Thanks a lot

@DanishDataDude Жыл бұрын

You just saved my day with this video. Thanks!

@GoodlyChandeep Жыл бұрын

Glad it helped!

@phanibabu7408 Жыл бұрын

This video has been very helpful to me. Thank you for sharing it. The video shows how to apply this to pivot tables. Can we apply it to graphs as well? Actually, I'm looking for a video like this to help me change the names of the fields in the graph.

@SuperJiooo 3 жыл бұрын

Thank you!

@kirtigoel6871 4 ай бұрын

very helpful !!

@suganya48 2 жыл бұрын

this is very helpful for single selection on slicer. Is there any way to do multi-selections in slicer?

@datalab365 2 жыл бұрын

Thanks you.

@staybreezy6079 3 жыл бұрын

Thank you Goodly! Very helpful!

@GoodlyChandeep 3 жыл бұрын

Glad it was helpful!

@mohdmuzammil3059 3 жыл бұрын

@@GoodlyChandeep chandeep FYI instead of blank if you use +0 at the end measure will get 0 it looks good

@vineetyoutubr5 4 жыл бұрын

Thanks alot buddy 😊

@nehashahpatel1741 2 жыл бұрын

million thanks

@amrfayad9297 9 ай бұрын

Thank u very much ,

@Wzxxx 2 жыл бұрын

It seems it is the best dax channel i found so far.

@GoodlyChandeep 2 жыл бұрын

Thank you for your inspiring words! 😊

@Wzxxx 2 жыл бұрын

@@GoodlyChandeep You are welcome. You can explain tricky things in the way people can understand. This is a nice skill especially with DAX which seems a pure evil, at least for me🙂

@venkatkirankumargollapinni4488 3 жыл бұрын

You are amazing bro

@tlee7028 2 жыл бұрын

Awesome Tutorial !

@GoodlyChandeep 2 жыл бұрын

Thank you 💚

@isidrebague3659 4 жыл бұрын

Excellent explanation Chandeep. Thank you

@GoodlyChandeep 4 жыл бұрын

Thanks, I am glad you liked it :)

@adetolaolabanji8839 2 жыл бұрын

thank you,

@subhasishdey2670 Жыл бұрын

Awesome.

@alessandropizzotti932 Ай бұрын

There's an easy way to have the column header change dynamically: add your measure to the columns of the table and hide the column subtotals.

@sreeshinet 3 жыл бұрын

Thanks

@mohitmanwani5298 4 жыл бұрын

Hi Chandeep, You can even give dynamic naming by using Title = IF(ISFILTERED(Slicer table[Selection]), VALUES(Slicer table[Selection]) & "by Date", "Please select single value from slicer"). I hope you will find useful

@GoodlyChandeep 4 жыл бұрын

Thanks Mohit :)

@KawanExcel 3 жыл бұрын

is that suggestion actually work , Chandeep ?? I am not sure, please let me know Thanks

@SMITDEDHIA96 4 жыл бұрын

Amazing as always... Thanks for sharing! Could you share a screenshot of how the dynamic "Calculation" column would look like when no value in slicer is selected?

@GoodlyChandeep 4 жыл бұрын

Check out the last gif in the blog. Links are below

@SMITDEDHIA96 4 жыл бұрын

@@GoodlyChandeep Got it! Thanks again.

@tsepomokau496 3 жыл бұрын

Awesomeness

@alpesh417rt 3 жыл бұрын

Hi cool video , quick question : here in this example we are passing text in a slicer - do we have the ability to pass date from a slicer and built a measure

@fahmywaleed 5 ай бұрын

Great video, quick and straight to the point with no fluff. Eventually did you find a fix to the column header as this is 3 years old video?

@GoodlyChandeep 5 ай бұрын

Yes now using a native feature called field parameters

@foxysatisfying675 4 ай бұрын

@@GoodlyChandeepDid you make video on that?

@briantey6997 2 жыл бұрын

Hi. Thanks for sharing. Wanna ask how about If I want show few column when selected one value in slicer? this only can show one column max

@richieakparuorji4296 3 жыл бұрын

i really appreciate this video. Also, what if i want to show more than 1 selected measure and also a sumproduct of all measure to always show depending on the number of selected measure

@HarshaVardhan-mx2lk Жыл бұрын

did you got the solution for this ?

@davidignatius1 Ай бұрын

Seems no solution?

@jaanun6549 2 жыл бұрын

Excellent sir, please post different slicer, if any new videos

@richardparson1 2 жыл бұрын

Thanks for an excellent explanation! Do you know how the code can be adjusted if we want to select and display several unrelated measures on the same chart/visual?

@deepikagangeswaran3656 2 жыл бұрын

I am looking for the same too. What if I want to select multiple options from slicer to display total sales and total units etc

@laalaajonsen Жыл бұрын

Have a look here guys: kzfaq.info/get/bejne/mbpoadOrreCUYWw.html

@davidignatius1 Ай бұрын

Seems no solution?

@atulshukal4072 4 жыл бұрын

Good Sir

@SaniGarba 4 жыл бұрын

Always great following your tutorial. Could I,mid I may, request a tutorial on Parameters and Functions, please

@GoodlyChandeep 4 жыл бұрын

Sure.. I'd do that soon

@MrRohanroxx1 2 жыл бұрын

Really cool Trick !! But I had a doubt How to sort this dynamic measure created in asc/ desc order and not show numbers in any order ?

@JoaoVictor-fh4on 2 ай бұрын

this is vey good, i have a problem that id like to solve and havent been able to. so, in your calculation measure, you had to list every value-condition pair by hand inside the switch function. Id like a way to automate that, so that if a User adds a collumn to the database, it automatically detects that i want the column with that name. I was able to make the slicer table automatic, so every time a user adds a column, the slicer table gets one more line, but i cant do it inside the switch function.

@surender665 2 жыл бұрын

Hi, You are real dax master, I have one query if I want to select multi measure in slicer and output should be show in matrix for exp. If I select Total sale, Total unit then matrix show me two fields(Value) as per my selection. How can we apply it.

@arghyadutta9091 Жыл бұрын

Great

@3danim8r1 3 жыл бұрын

Great tutorial..Can we add multiple measures on single slicer selection?

@ginesc 2 жыл бұрын

Yes you can :-) the table Chandeep has created has just one column, but if you create two columns Qty - Act Sales || Qty - LY Sales || Value - Act Val Sales || Value - LY Val Sales, whenever you click on Qty or in Value two measures will be visible in your report (if needed more , of course).

@manojhub 3 жыл бұрын

Great video. Can we provide SELECT ALL option for user if they would like to select all measures in one go?

@GoodlyChandeep 3 жыл бұрын

Well technically you can, in that case you'll need to add a scenario in the DAX measure that shows all the calculations in a presentable way!

@jayaraju6169 Жыл бұрын

Thank you So much Brother, your video helped in getting solution in project. But there is one glitch, I'm not able to apply Color Condition for the output. (I've made the measure as %). Please advise. Thanks again.

@user-io2jm1qd6u Жыл бұрын

How do we change the format type of the diff measures ( %, currency etc) within the switch calculation measure?

@ManuVats1990 2 жыл бұрын

How can we sum the measures according to the selections made in the slicer? For eg. I have columns as Jan sales, Feb sales, Mar sales and so on. I have created a slicer table and the required measure. But I want to add these column values according to the selections made in the slicer. For eg. if I select Jan sales and Feb sales from slicer, a card should show me sum of Jan sales and Feb sales.

@JacobClayton619 2 жыл бұрын

Do you know how this same measure can be applied to a chart? For some reason, my calculation is stuck as a "TEXT" datatype not allowing me to place it in the values. When I add in a convert to Integer function to the measure it works for all of my metrics besides any values under 1. I have a specific metric which shows in decimals and its not displaying the data. Any ideas?

@yogeshthorat732 Жыл бұрын

Hi Need your help, I have same condition to change the measure, but i want to change 3 measures at a time can we create group of measures and on selecting value in slicer respective measure group will displayed

@foxysatisfying675 4 ай бұрын

Hello. Did you found a way to change the column header name based on the slicer selection?

@celsocaetano84 11 ай бұрын

is there a way to select multiple at the same time? I am trying but it keeps returning wrong values

@user-ky6rk4wp5y 4 ай бұрын

does it support multiple selections?

@user-dj8qs6px6u 2 ай бұрын

Hallo, I just wonder, is it possible to make a slicer that would change for example units/values but not in one measure but in lets say 5 of them at once. I have current year units, previous year units, evolution , weight of business and I want to be able to switch between them by clicking on the slicer. Is that possible?

@anuragbawankar685 3 жыл бұрын

Thanks sir ! If I want to select and display 2 or more columns/calculations then how it can be done??

@GoodlyChandeep 3 жыл бұрын

I think it can be done using calculation groups

@anuragbawankar685 3 жыл бұрын

@@GoodlyChandeep Ok sir , just saw your calculation group video , Thanks a lot !!!!

@marliearcellia1289 3 жыл бұрын

Can we do multi selection and let the table shows them?

@pritishah6035 2 жыл бұрын

Thank you very much . Your video helps a lot ..how you derived Month format in "MMM" Is thr any Dax if so Please share

@GoodlyChandeep 2 жыл бұрын

=FORMAT ( Date[Date], "mmm" )

@pritishah6035 2 жыл бұрын

@@GoodlyChandeep Thank you for your reply...in this case new column is text column instead of Date format..how to resolve this concern

@mahathmasadineni2884 2 жыл бұрын

Is it possible to change the query also based on slicer selection

@luisalonso3018 6 ай бұрын

Hi, huge thank you! However, when I insert the "calculations" measure into a line graph, it won´t display it. I changed the "Select a calcluation" text to a 1 and it still did not do it. Any help will be greatly appreciated it!

@patelekta9242 Жыл бұрын

How can we convert or use calculation to show percentage of Grand Total?

@NaraMeerammaTrust 3 жыл бұрын

If I wanted to have a format to show my total sales in currency Format having $ Symbol. What is the way to achieve it. Appreciate if you can reply to this Issue. Thank you

@GoodlyChandeep 3 жыл бұрын

wrap the Total Sales in the Format Function = FORMAT ( [Total Sales], "Currency" ) Read this post - www.goodly.co.in/dax-format-function/

@nimikajadav3004 12 күн бұрын

I want to get rate from users then want to convert into that rate . how to do ? like if choosed INR then show INR value, if choose USD then pur rate from numeric range parameter and convert into USD using given rate , not manually put into table then convert. i need help.