Thank you for the video! So useful!

I just started learning bi, this comes in handy. Keep posting ! 👍😁

Great example, I have a customer who was looking to show a number of different metrics but wanted a slicer for volume and sales, but not show both at the same time.

Hello, is there a way to display them separately? for example, if Sales and Profit is selected, then it would show values for Sales and then another one showing values for Profit. Thanks for this video!

Thanks for this video very helpful video

Can we add one more thing to this i.e if I select sales then the column header which dynamic value currently should change to sales?

It doesn't work quite well in my case, are there any relationships we need to define between the slicer table and the main table.? This only works for the Sales and it seems it's because it's the default defined when nothing is chosen in the slicer. When I select other options the table does not update

try zooming in so that we can clearly see the formula

Thank you for the tutorial, but can i use this example to apply Dax to select value from different table base on slicer selection. Many thanks for your help. 🙏

Hello and thanks for the video! Has already helped a lot. I've done this, but FORMAT formula results as a text and I'm unable to let the user sort by the value (it sorts based on a 0 to 9 scheme, returning numbers where 9 is the first number when I sort descending, for instance). Do you have any suggestion for resolving this problem? Again, thank you!

What if i want to display multiple columns what are selected in slicer, thanks

Hi, this is quite interesting, I am trying to display more than 1 measures in a table based on the slicer selection. Eg if I have selected Dollars then show all measures with Dollars eg Dollar Sales, Dollar Market share. I tried adding them as value 2, measure 2 but it starts to sum all of them. ANy help would be appreciated

If I'm not having the "Sales" , "Profit", & "Profit %" as measures. But Instead of measures I'm having it as normal column in the table. Then how to do this same ?

Can you do a video on same period last year for multiple years based on slicer selection? That is, you have 3, 4 or 5 years worth of data. Same Period last year only works for comparing two years. This time, you have multiple years. Well, as a second step, I want to be able to select months (say, Jan, Feb, March of 2021 and the card shows the percentage change from Jan, Feb, March of 2020. And, when there is no period to compare to, or if multiple years are selected, it returns a string saying, "Invalid Selection")

Can you post the PBIX file for this?

Hi, U cracking. Kindly add the video power bi Automate.🤔

Instead of switching measure used as a column, can we switch table columns? I saw one more comment like this where you have answered to use (Calculate fn and sum up the columns) but in my scenario i want to switch Text Data type columns which can't be aggregated.