Display different Columns in a Table based on the Slicer selection using SelectedValue function combined with SWITCH Statement | MiTutorials
Пікірлер: 31
@user-kk5zb5zo5b Жыл бұрын
Thank you for the video! So useful!
@charlessaputra8172 жыл бұрын
I just started learning bi, this comes in handy. Keep posting ! 👍😁
@MITutorials2 жыл бұрын
Happy to hear that!
@feldy316832 жыл бұрын
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.
@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!
@piyushdubey6482 Жыл бұрын
Thanks for this video very helpful video
@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?
@tiisetsomashele14946 ай бұрын
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
@ManishaSingh-hx6ly5 ай бұрын
try zooming in so that we can clearly see the formula
@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!
@felipetoniolo12192 жыл бұрын
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!
@MITutorials2 жыл бұрын
Please see this tutorial, you will have to use the similar logic. hope this helps. kzfaq.info/get/bejne/e7yVq5x425Osn58.html
@koteswaribapatla8075 Жыл бұрын
What if i want to display multiple columns what are selected in slicer, thanks
@shekharokhde5692 жыл бұрын
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
@MITutorials2 жыл бұрын
You can achieve this by watching the latest tutorial on my channel. I have posted a video about this.
@shekharokhde5692 жыл бұрын
@@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 ?
@vivekkarthik41272 жыл бұрын
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 ?
@MITutorials2 жыл бұрын
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 kzfaq.info/get/bejne/g95mYJSayK_DaI0.html
@omenaokoro4693 Жыл бұрын
@@MITutorials yes, it is! Thank you so much.
@jenniferw11032 жыл бұрын
Can you post the PBIX file for this?
@MITutorials2 жыл бұрын
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 :) kzfaq.info/get/bejne/q62ZoteQnJyviGQ.html
@balajithandavan68422 жыл бұрын
Hi, U cracking. Kindly add the video power bi Automate.🤔
@MITutorials2 жыл бұрын
What do you want to do with Power automate ?
@shubhammittal6509 Жыл бұрын
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.
@MITutorials Жыл бұрын
This should help you New Feature 🔥 | Dynamic Slicers in PowerBI will take your Dashboard to next level | MiTutorials kzfaq.info/get/bejne/hLWciJef3b2ddoE.html