What a great teacher you are..your videos are amazing! I've been learning Power BI recently and many times I get stuck. Watching your videos is helping me a lot. Thank you so much!
Wow. you are a genius. This really helped me solve a problem in my work. Thank you! I shall most certainly be purchasing your books and courses in future!! Thank you again!!!
Wow, you read my mind 🙂. Currently we're building the same, with one additional requirement. i.e., the visual should then get to the details page using drill through. I'm trying a work around for it using treatas, since I have slicer table as disconnected table. I believe if state and country were in different tables then also we can make this work. Thank you 👍
Hello Thanks for sharing the steps very clear, but I have one Month Slicer and date getting from A1 Column. I have another Slicer for Open Close Status, When I click on Open Slicer Month Slicer should take data from A1 column. When I click on Close Slicer Month Slicer should take data from A2 column Is this possible ?
Thanks for the video, How can you make a slicer to filter two columns in same table? Example: if I select "Red" it will filter the rows were Mother's favorite color Or Dad's Favorite color is red??
Great video. I have an accounting report with dozens of attributes and measures and I want to let user filter the columns they need to see. Have you published a similar resource?
Hi Alberto, this is an awesome video that teaches a lot of nitty-gritty of how everything is interconnected in DAX. Can you please share your slicer settings? Are you using a custom slicer visual? I am only getting vertical lists, tiles and dropdowns, not labels with cross marks like yours nor can I type the names of places to add them to my slicer, like you are doing.
Take a look at Smart Filter and Smart Filter Pro (Alberto probably used the latter in the demo, but there are several features also available in the free version). okviz.com/smart-filter/ okviz.com/smart-filter-pro/
Dears I'm struggling with a similar situation. I have a fact table with several attributes, and for two of those, same values may apply. For example if one is salesman and another salesrep, but same person can be in both columns. How can I build a slices that at same time will show records where this name shows as salesman or salesrep. Many thanks in advanced.
Hi Mr. Ferrari, love your work. I have a question for you. Is it possible to create a model table from an existing Matrix Visual? The reason for asking is I am trying to create a dynamic column selection on a Matrix. To do that, I would need to have the table so I can unpivot some columns, then use a slicer to add / remove column on a newly built Matrix. Makes sense?
Thanks for great tips !! Could you please also share how to create single slicer when there is a Date table is linking to both Customer and Sales and no relationship between Customer and Sales Table ? I am having this scenario and powerbi return circular dependency error with this method....
Hello, Thanks for this video. I have a scenario . Can you please help me on that. I have a table with 8 columns . I need to access the table by it's column name. So i need to add the column names as the slicer values. How am I supposed to do that?
You cannot - you should create a table with the list of column names and adapt measures accordingly, but you don't have an automatic way to do that. DAX doesn't have meta-programming.
Hi, it is good, but with out using bidirectional, we can implement this by using merge columns in power query. Kindly suggest my understanding is correct.
This was a great video! I have followed your steps and everything is working perfectly! My categories are District, County and City. I had a formula to calculate the rank of each city included in a table regardless of the filters that were applied. Before I used the slicer Smart Filter Pro, I was using 3 separate slicers, one for District, one for County and one for City--with these slicers, the Rank formula was working correctly. However, once I used the Smart filter Pro slicer, the rank was ranking only the items in the table that had been selected. Do you have any ideas of how I can make the Rank formula ignore the slicer for Smart Filter Pro? Thank you in advance.
There are many details involved and it's impossible to provide an answer without a repro. It would be better if you write a comment in the article page including the rank formula adapted for the sample file we use, otherwise we cannot reply if you reference your custom model. In general, you might want to use the third argument of RANKX, with a different expression for the current value (third argument, just as the measure you use now) and the comparison value (second argument, you probably want to remove additional filters there).
Is there a way to create a similar slicer where I can select multiple distinct values, for example, "United States" and "California", and return only rows that contain BOTH those 2 values? The way your model and slicer is set up right now will return all rows that contain EITHER value.
Just for curiosity: Why do you prefer to filter the Customer table with your slicer table and not your fact (Sales) table, which would be closer to the star scheme? You could also add the CountyState key to the fact table, and the slicer and the graph in your report would show the same result.
Through Your articles and videos I got the job in one of the best companies. Always waiting for your videos to make me as Powerful power bi Developer
What a great teacher you are..your videos are amazing! I've been learning Power BI recently and many times I get stuck. Watching your videos is helping me a lot. Thank you so much!
Alberto is my favourite. And his explanation is very simple and clear.
Definetly, I'm so proud to be student to SQLBI. Thanks Alberto!!!!
You just helped me solved my biggest headache of the week. Thank you so much for this, Alberto.
Wow. you are a genius. This really helped me solve a problem in my work. Thank you! I shall most certainly be purchasing your books and courses in future!! Thank you again!!!
This is great demo video, very easy to follow for novice power bi user!!!
I really love data modeling, this video is golden, thanks for sharing!
Thank you! This was a very special scenario to explain in depth, solved my requirement!
It's such a delight to learn from you.. every session is a true gem. Thank you so much.
Than you so much!!! I love how you explain, so easy to understand!!
Great solution sir, salute your hard work, love from India
That's great! ,I am using this kind of techniques of mapping tables to handle such granularity issues,
That always works perfectly.
Wow, you read my mind 🙂. Currently we're building the same, with one additional requirement. i.e., the visual should then get to the details page using drill through. I'm trying a work around for it using treatas, since I have slicer table as disconnected table. I believe if state and country were in different tables then also we can make this work.
Thank you 👍
Thank you so much, Alberto. You are the Master Manipulator of DAX.
This is an amazing technique. Thanks a lot for making this video
Alberto great work and insight! thank you for sharing with us
Hello Thanks for sharing the steps very clear, but I have one Month Slicer and date getting from A1 Column.
I have another Slicer for Open Close Status,
When I click on Open Slicer Month Slicer should take data from A1 column.
When I click on Close Slicer Month Slicer should take data from A2 column
Is this possible ?
Great video. Well explained!
This is awesome, you guys are PowerBI hero!!
This is so awesome. Thank you for all your content!!
Thanks for the video,
How can you make a slicer to filter two columns in same table?
Example: if I select "Red" it will filter the rows were Mother's favorite color Or Dad's Favorite color is red??
What a nice video. Which visual is it used to enter text ?
Great video. I have an accounting report with dozens of attributes and measures and I want to let user filter the columns they need to see. Have you published a similar resource?
Magic it is! Thanx again Alberto
Really useful! In my case the second option takes less than the 50% of time.
Very usefull and well explained ! Thanks a lot for this time saver video !
Hi Alberto, this is an awesome video that teaches a lot of nitty-gritty of how everything is interconnected in DAX. Can you please share your slicer settings? Are you using a custom slicer visual? I am only getting vertical lists, tiles and dropdowns, not labels with cross marks like yours nor can I type the names of places to add them to my slicer, like you are doing.
Take a look at Smart Filter and Smart Filter Pro (Alberto probably used the latter in the demo, but there are several features also available in the free version).
okviz.com/smart-filter/
okviz.com/smart-filter-pro/
@@SQLBI Thanks a ton! These small things matter a lot from the POV of report presentation
Thank you!! Very helpful!
clarified clear) thank you! 👍
Dears
I'm struggling with a similar situation. I have a fact table with several attributes, and for two of those, same values may apply.
For example if one is salesman and another salesrep, but same person can be in both columns.
How can I build a slices that at same time will show records where this name shows as salesman or salesrep.
Many thanks in advanced.
Hi Mr. Ferrari, love your work. I have a question for you. Is it possible to create a model table from an existing Matrix Visual? The reason for asking is I am trying to create a dynamic column selection on a Matrix. To do that, I would need to have the table so I can unpivot some columns, then use a slicer to add / remove column on a newly built Matrix. Makes sense?
very useful...Thank you so much it helps lot!
Thanks for great tips !! Could you please also share how to create single slicer when there is a Date table is linking to both Customer and Sales and no relationship between Customer and Sales Table ? I am having this scenario and powerbi return circular dependency error with this method....
If you have a circular dependency you probably have a relationship between Customer and Sales...
Hello, Thanks for this video. I have a scenario . Can you please help me on that. I have a table with 8 columns . I need to access the table by it's column name. So i need to add the column names as the slicer values. How am I supposed to do that?
You cannot - you should create a table with the list of column names and adapt measures accordingly, but you don't have an automatic way to do that. DAX doesn't have meta-programming.
@@SQLBI Thanks , I'll create a new table with Column names and give a try.
Excellent very didactic class, Thanks Master
What if we want to do this columns comming from 2 different dimension table? Do we need to put the combined key column to fact table in that case?
Yes!
19:57 could this be expanded on with more details?
9:00 Table before adding key.
12:51 COMBINEVALUES Calculated Column.
13:42 Table after adding the combine CC to union.
15:15 Relationship
Thank you so much!
Grazie, Alberto!
Which slicer is used in above visualisation for searching values
Hi, it is good, but with out using bidirectional, we can implement this by using merge columns in power query. Kindly suggest my understanding is correct.
Thanks soo much... good solution...
This was a great video! I have followed your steps and everything is working perfectly! My categories are District, County and City. I had a formula to calculate the rank of each city included in a table regardless of the filters that were applied. Before I used the slicer Smart Filter Pro, I was using 3 separate slicers, one for District, one for County and one for City--with these slicers, the Rank formula was working correctly. However, once I used the Smart filter Pro slicer, the rank was ranking only the items in the table that had been selected. Do you have any ideas of how I can make the Rank formula ignore the slicer for Smart Filter Pro? Thank you in advance.
There are many details involved and it's impossible to provide an answer without a repro. It would be better if you write a comment in the article page including the rank formula adapted for the sample file we use, otherwise we cannot reply if you reference your custom model.
In general, you might want to use the third argument of RANKX, with a different expression for the current value (third argument, just as the measure you use now) and the comparison value (second argument, you probably want to remove additional filters there).
Which slicer visual you used for this demo?
Smart Filter Pro: okviz.com/smart-filter-pro/
A free version is also available in the App Store, even though with less features.
please help i need to make an autoincrementing filter in power bi on a week basis
This is very good
What visual were you using for the slicer? That doesn't look like the standard slicer.
Smart Filter Pro: okviz.com/smart-filter-pro/?aff=yt
There is also a free version (Smart Filter) on AppSource.
Is there a way to create a similar slicer where I can select multiple distinct values, for example, "United States" and "California", and return only rows that contain BOTH those 2 values? The way your model and slicer is set up right now will return all rows that contain EITHER value.
It's explained here: www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/
Just for curiosity: Why do you prefer to filter the Customer table with your slicer table and not your fact (Sales) table, which would be closer to the star scheme? You could also add the CountyState key to the fact table, and the slicer and the graph in your report would show the same result.
You would face auto-exist issues: www.sqlbi.com/articles/understanding-dax-auto-exist/
Very useful 🙏
what if we have multiple values, say "scenarios" column as values SC1; SC1; SC1 and Run "Column" has 1;2;3 , and then all other columns
Which filter visual are you using?
Smart Filter Pro: okviz.com/smart-filter-pro/?aff=yt
There is also a free version (Smart Filter) on AppSource.
Which visualization do you use in this video?
Smart Filter Pro:
okviz.com/smart-filter-pro/
@@SQLBI Thank you
Perfect
Please provide the data set for which these video's are done.
You can find the link to download the sample in the description of the video.
Can someone please tell me which is the visual on the left whcih is being used as slicer?
Smart Filter Pro, there is also a free version with fewer feature on the store (Smart Filter).
okviz.com/smart-filter-pro/
okviz.com/smart-filter/
My Visual Filters don't look like yours and I'm running June 2021.
Ciao friend 😃😃😃😃
Only four screens? ;)