Display different Columns in a Table based on the Slicer selection using SELECTEDVALUE | MiTutorial

Display different Columns in a Table based on the Slicer selection using SelectedValue function combined with SWITCH Statement | MiTutorials

[piyushdubey]

Thanks for this video very helpful video

[charlessaputra]

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

[reticulan]

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!

[kshwatch]

Hello, instead of measures how can I accomplish this with dimensions? So instead of sales or profit or profit%, I want to use the slicer to select a specific dimension column in the table. Is that possible?

[vaibhavahirrao]

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?

[argokusumandani]

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. 🙏

[feldy]

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.

[tiisetsomashele]

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

[koteswaribapatla]

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

[ManishaSingh-hxly]

try zooming in so that we can clearly see the formula

[felipetoniolo]

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!

[shekharokhde]

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

[vivekkarthik]

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 ?

[omenaokoro]

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")

[balajithandavan]

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