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

[@InnaBerezanskaya]

Thank you for the video! So useful!

[@charlessaputra817]

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

[@MITutorials]

Happy to hear that!

[@piyushdubey6482]

Thanks for this video very helpful video

[@charotarguy1]

Sir, I want to add a column in a dataset table . this column should be selected value from slicer ... how do i do this.. i am getting default value of slicer and not selected. ( slicer i have made from different table whhich has no relationship

[@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?

[@vaibhavahirrao7484]

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?

[@rapatel1642]

What happens if I want the user to select a value from the slicer but the value appears in a cell. That is Sub category item is appliance it shows Profit if profit selected and for Accessories I selected sales and it shows sales for the cell while keeping the Profit for Accessories How do I do that.

[@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!

[@argokusumandani9773]

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

[@MITutorials]

Yes you can!

[@tiisetsomashele1494]

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

[@feldy31683]

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.

[@omenaokoro4693]

a toggle is used to achieve that. I got impatient with implementing a toggle so I created and hid a report and used a button in place of a toggle.

[@koteswaribapatla8075]

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

[@ManishaSingh-hx6ly]

try zooming in so that we can clearly see the formula

[@felipetoniolo1219]

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!

[@MITutorials]

Please see this tutorial, you will have to use the similar logic. hope this helps. kzbin.info/www/bejne/e4fIqWx9q5J7pc0

[@shekharokhde569]

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

[@MITutorials]

You can achieve this by watching the latest tutorial on my channel. I have posted a video about this.

[@shekharokhde569]

@@MITutorials Thanks for this.. I watched the video but it did not solve my issue. I have 4 columns "Sales, Market Share, Growth and EI" I have these measures based on Dollars and another 4 based on Units. I want to create a slicer for Dollars and Units only and when Dollars is selected all the columns associated with Dollars come up and when Units is selected all columns based on Units are displayed.

[@paullemonnier3168]

@@shekharokhde569did you find a solution to this my friend ?

[@vivekkarthik4127]

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 ?

[@MITutorials]

Use the calculate function and sum the values

[@pengyu4245]

@@MITutorials Which tutorial video gives details about creating “ sales”,”profit” and “profit %” ? Thx!

[@omenaokoro4693]

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

[@MITutorials]

I guess this is what you are looking for. Compare Amount of this Year/Month vs Last Year in PowerBI | PowerBI Tutorial | SamePeriodLastYear kzbin.info/www/bejne/g6mZXmSfmK6Sbrs

[@omenaokoro4693]

@@MITutorials yes, it is! Thank you so much.

[@jenniferw1103]

Can you post the PBIX file for this?

[@MITutorials]

There is a new feature in BI which does this in the most simplest way.. Please watch this tutorial and you wouldn't need a PBIX file :) kzbin.info/www/bejne/q3jMoKeVbJt-jpI

[@balajithandavan6842]

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

[@MITutorials]

What do you want to do with Power automate ?