Today marks almost a year since I started watching the videos of this legend. The Power BI design tips and end-user experience enhancements I’ve learned from you, Mr. Bas, are truly unforgettable. I remember creating my first report using a background template after watching your video, and it received a lot of appreciation in my organization Keep it up, legend Mr. Bas. Your channel should be called 'Boss of Power BI'! ❤️
Man, this advanced stuff is SUCH a good resource to get for free. I'm sure there's going to be some people who find it too detailed, but the rest of us know how lucky we are. I'm trying to solve this fields parameter sort order nuance RIGHT NOW at work, and this is a solution I can just walk in with tomorrow. Thank you Bas!
Gratitude for this video. I was working on a portfolio project last night and spent an hour trying to figure out why I couldn't get the selected value from a parameter field to no avail.
Thats was a great follow along and highligted the use of field parameters great! I got two tiny little nitpicks: The measures, at first i was like why don't u use a variable and formate at the end then u even created the base measure lol. Haven't tried it yet but the following should work? I will come back to this when I tried it for myself. M1: Selected Metric Value like in the end M2: Selected Metric Value Formated = Format([Selected Metric Value],"###0,,.0M") Second: In the Parameter you could have just changed the regular sorting parameter to 1,2,3,1,2,3 for the categorie and sorted by tihs without complication and no extra column. Still a great show of the tools we got keep it up!
Hello! Thanks for the video, I learned a lot of new things! I use parameters to create dynamic grouping in matrices (placing them in rows). It turns into a matrix constructor. The grouping order depends on the sequence of selection in the slicer. I wonder if it's possible to display the order or make the grouping order selection more intuitive?
@@HowtoPowerBI I want the user to define the grouping order. I tried to write my own visualization (with checkboxes and up/down arrows that change the order when clicked). I managed to make it possible to toggle measures on/off and move them with the arrows, but I couldn't influence the visualizations. P.S. My English isn't very strong.
@@vladositto AFAIK there is no way to read the order of the selection, you can use a concatenatex and summarize to extract the active selections, but the order will always be the same than the field parameter table.
I wish I had watched this video last week! I needed to show 4 different visuals based on user choice and I spent almost 45 min trying to get my bookmarks to work like I wanted!!
Great work as usual. Currently have a funnel chart showing the cost breakdown, but when I change the product type using the slicer, the sorting gets messed up.
Another tip for sorting. When using Field Parameters and you change the selection, the visual sort order is lost, thus defaulting to an ascending order. But this order is not always what you think of as ascending. To fix this I created another column in my parameter that went the opposite cardinality of the sorting column (4,3,2,1 instead of 1,2,3,4), which can then be used as the Sort By column. This will create a descending sort order even though the default condition is ascending.
@@HowtoPowerBI yes you must still collapse the column, I will just sleep better at night knowing that there is nothing inside the column 😂 imagine Microsoft added a right click function like Excel to hide columns
How do you create that metrics “table/folder” that you use here? 1:15 And besides the organizational benefits are there any other benefits to doing it?
one quick hack to fix the sorting issue - Just create an empty measure (insert just ... inside " ") and then insert this in tooltip of the visual and in sorting option of visual select sort by that measure which was created . This will fix the sorting issue and it works like wonder.
Bookmarks are far inferior in my opinion, I would only use them when the visual type or design has to change with selection, for example a chart has to turn into a table, etc. It's a lot more work to set them up (especially if there are more than 2-3 options) and you can't do multiple parameters (the main issue for me); even for the rather simple example in the video, there are essentially two parameters (metric and to date/not to date) - how would you do that with bookmarks only? You would have to have a parameter anyway. Also, bookmarks require more maintenance effort. Let's say a user asks to change something about a visual (color, font, visual type, etc) - with parameters you are changing one visual, while with bookmarks you have to do many more changes since it's a separate visual for every option.
Now that you are also in the Whoop user club like me, perhaps a PowerBI report with data from the Whoop API would be interesting. To see if you can get even more out of it than the app already shows us :)
I've been playing with field parameters a lot lately myself. I've been trying to group measures from the field parameter in a matrix by putting the grouping column in the row/column field. however all measures appear under each group in this case even though they are not assigned to this group. Any ideas? I tried writing some dax to filter the visual but doesn't seem to work.
Why, when I change my bar chart to my new field, does no data show up? It will show up for any other visual except the bar charts! It's driving e insane! Please help! Also, I love you videos keep it up.
Hi, I met a problem, maybe you have solution for this. I have a normal slicer in a page with two values, e.g. 1 and 2. These effect to all visuals on the page. And I use field parameter with 3 measures in a visual in this page: A, B, C. I want to reach the follow cases: Normal slicer slices Field parameters measueres: Value 1 selects Measure A, Value 2 selects Measure B and if both of them or none of them are selected is Measure C. I havent got perfect solution. The solution with field parameter is important because i need also a dynamically changed measure name in the particular visual.
I have worked on more advance scenario with field parameter, Scenario: I have dimension as Dim_Factory and Dim_Product_Hirarchy so created a parameter out of these two table with ID and Description and tuned parameter to have common clubbed name for ID and Description Like Factory_ID and Factory_Description clubbed under Factory BU_ID and BU_Description clubbed under Business Unit Then I added this parameter into matrix visual along with clubbed as slicer and set clubbed slicer as single select at first glance it is working fine by manually drilling from ID to Description However when user change the clubbed slicer from Factory to Business Unit then it automatically shifts the hierarchy to ID instead staying at Id and Description Is there any way to fixed this ?
You cannot choose a different custom tooltip. But you can use the parameter in the visuals that you show on the custom tooltip so that it shows the selected metric
@@HowtoPowerBI thank you so much for reply but I have like 4 pages almost 10 visual per page ,and each visual has different dimensions so it will be really hectic task to create custom tooltip to each
Hey Bas, I always watch your videos. I wish you would help me with this problem. The dataset is being pulled from SQL server but is too big to import to PBI, so I'm trying to use a parameter directly in power query so it only shows me the information I want. I manage to do this with direct query and the parameter value is passed from the PBI Dashboard through a slicer. It works really well, starts doing the query every time a new ID is passed but when I try to publish to PBI service it says "Your file was published, but disconnected. The report is not connected to one or more data sources. To connect, go to dataset settings or ask the dataset owner for help". My best guess is that since I am using direct query, it doesn't have any data in the report. How can I use this report in power BI service?
@HowtoPowerBI it's really really big. The query is big and complex that does a lot of joins. It's not made to bring all persons information at the same time. I've tried running the query without parameters just to see how much it would take and let it load for half an hour and it didn't even show the first row. It has all employees' history since the beginning of the company, and it's a big company, so it makes sense that it's a lot of records.. I dare to say millions.
Hi mate, I have seen this message before, and every single time was because of a non existing connection in the PBI service, I mean, in the desktop exist but not in the service yet. Once I config all the gateways properly inside the dataset (now called semantic model), everything works just fine and the message never shows up again.
Today marks almost a year since I started watching the videos of this legend. The Power BI design tips and end-user experience enhancements I’ve learned from you, Mr. Bas, are truly unforgettable. I remember creating my first report using a background template after watching your video, and it received a lot of appreciation in my organization
Keep it up, legend Mr. Bas. Your channel should be called 'Boss of Power BI'! ❤️
Man, this advanced stuff is SUCH a good resource to get for free. I'm sure there's going to be some people who find it too detailed, but the rest of us know how lucky we are.
I'm trying to solve this fields parameter sort order nuance RIGHT NOW at work, and this is a solution I can just walk in with tomorrow. Thank you Bas!
Gratitude for this video. I was working on a portfolio project last night and spent an hour trying to figure out why I couldn't get the selected value from a parameter field to no avail.
Thats was a great follow along and highligted the use of field parameters great!
I got two tiny little nitpicks:
The measures, at first i was like why don't u use a variable and formate at the end then u even created the base measure lol.
Haven't tried it yet but the following should work? I will come back to this when I tried it for myself.
M1: Selected Metric Value like in the end
M2: Selected Metric Value Formated = Format([Selected Metric Value],"###0,,.0M")
Second:
In the Parameter you could have just changed the regular sorting parameter to 1,2,3,1,2,3 for the categorie and sorted by tihs without complication and no extra column.
Still a great show of the tools we got keep it up!
"CTRL + SHIFT + L" key shortcut is the best feature ever!!!! Thank you for that man.
You are Truly a Inspiration for Creativity with Power BI.
God Bless you
😃 happy to hear that , thank you
Hello! Thanks for the video, I learned a lot of new things! I use parameters to create dynamic grouping in matrices (placing them in rows). It turns into a matrix constructor. The grouping order depends on the sequence of selection in the slicer. I wonder if it's possible to display the order or make the grouping order selection more intuitive?
So you dont want them in order of selection, but a custom sort order set by you?
@@HowtoPowerBI I want the user to define the grouping order. I tried to write my own visualization (with checkboxes and up/down arrows that change the order when clicked). I managed to make it possible to toggle measures on/off and move them with the arrows, but I couldn't influence the visualizations.
P.S. My English isn't very strong.
@@HowtoPowerBI And I would like at least to have the ability to see the grouping order through a label.
@@vladositto AFAIK there is no way to read the order of the selection, you can use a concatenatex and summarize to extract the active selections, but the order will always be the same than the field parameter table.
Great video as always. For the Parameter Secret 1 my Label field option in the new slicer is greyed out and I'm not sure why.
Thank you Bas, in fact I used this today to enhance the user experience when they wanted to switch between currencies.
I wish I had watched this video last week! I needed to show 4 different visuals based on user choice and I spent almost 45 min trying to get my bookmarks to work like I wanted!!
Better late than never?! 😁
Great work as usual. Currently have a funnel chart showing the cost breakdown, but when I change the product type using the slicer, the sorting gets messed up.
Another tip for sorting. When using Field Parameters and you change the selection, the visual sort order is lost, thus defaulting to an ascending order. But this order is not always what you think of as ascending. To fix this I created another column in my parameter that went the opposite cardinality of the sorting column (4,3,2,1 instead of 1,2,3,4), which can then be used as the Sort By column. This will create a descending sort order even though the default condition is ascending.
Hi, can you make a video on how to improve the self serve capabilities for the end user in power bi, where they can make reports on their own
@6:00 I would recommend using dynamic formatting and use the same switch function with the format text instead. Makes life easier when exporting data
I love this solution, Bas! Thanks so much for a new tool that I will use in every report!!
Baie dankie Bas!
Your last point for the matrix, you can also add ;;; in the format on top to make the numbers disappear.
that would leave the column visible though ,.. but without any values visibly showing in it
@@HowtoPowerBI yes you must still collapse the column, I will just sleep better at night knowing that there is nothing inside the column 😂 imagine Microsoft added a right click function like Excel to hide columns
really nice video. these are the typical issues I was struggling with. Great stuff
Hi Bas, nice content as always!
How do you create that metrics “table/folder” that you use here? 1:15
And besides the organizational benefits are there any other benefits to doing it?
Excellent.... nice trick 👌.... thanks for sharing 🎉
Thanks Bas...
You are the Boss ❤
Lots of blessings for you....
Amazing as always...
Superb outstanding content😊 ❤❤😊
thank you so much, appreciate the nice words :D
Thanks Bas, informative as always 🙂
Thx for watching again 😃
Excellent, as always! 👍
dankjewel Wilco!!! 😁 groetjes
one quick hack to fix the sorting issue - Just create an empty measure (insert just ... inside " ") and then insert this in tooltip of the visual and in sorting option of visual select sort by that measure which was created . This will fix the sorting issue and it works like wonder.
I've been using bookmark buttons to achieve a very similar result. Would you recommend bookmark buttons or parameters?
Bookmarks are far inferior in my opinion, I would only use them when the visual type or design has to change with selection, for example a chart has to turn into a table, etc. It's a lot more work to set them up (especially if there are more than 2-3 options) and you can't do multiple parameters (the main issue for me); even for the rather simple example in the video, there are essentially two parameters (metric and to date/not to date) - how would you do that with bookmarks only? You would have to have a parameter anyway. Also, bookmarks require more maintenance effort. Let's say a user asks to change something about a visual (color, font, visual type, etc) - with parameters you are changing one visual, while with bookmarks you have to do many more changes since it's a separate visual for every option.
Now that you are also in the Whoop user club like me, perhaps a PowerBI report with data from the Whoop API would be interesting. To see if you can get even more out of it than the app already shows us :)
lol, yea I've seen a yt video that did that ... maybe one day ;) .. first have to gather some data 😅
Amazing
Very informative.
Thanks for sharing.
Glad it was helpful!
I've been playing with field parameters a lot lately myself. I've been trying to group measures from the field parameter in a matrix by putting the grouping column in the row/column field. however all measures appear under each group in this case even though they are not assigned to this group. Any ideas? I tried writing some dax to filter the visual but doesn't seem to work.
Super, 👍 you are the best! 👌
Thx Alice
Why, when I change my bar chart to my new field, does no data show up? It will show up for any other visual except the bar charts! It's driving e insane! Please help! Also, I love you videos keep it up.
super! thanks for sharing
Hi, I met a problem, maybe you have solution for this. I have a normal slicer in a page with two values, e.g. 1 and 2. These effect to all visuals on the page. And I use field parameter with 3 measures in a visual in this page: A, B, C. I want to reach the follow cases: Normal slicer slices Field parameters measueres: Value 1 selects Measure A, Value 2 selects Measure B and if both of them or none of them are selected is Measure C. I havent got perfect solution.
The solution with field parameter is important because i need also a dynamically changed measure name in the particular visual.
Very good, as always!
😁🤓💻
I have worked on more advance scenario with field parameter,
Scenario:
I have dimension as Dim_Factory and Dim_Product_Hirarchy
so created a parameter out of these two table with ID and Description
and tuned parameter to have common clubbed name for ID and Description
Like
Factory_ID and Factory_Description clubbed under Factory
BU_ID and BU_Description clubbed under Business Unit
Then I added this parameter into matrix visual along with clubbed as slicer and set clubbed slicer as single select
at first glance it is working fine by manually drilling from ID to Description
However when user change the clubbed slicer from Factory to Business Unit then it automatically shifts the hierarchy to ID instead staying at Id and Description
Is there any way to fixed this ?
Just amazing!
You are the best 🕶! 🤩🤩🤩
probably not :P but thx for the compliment!
in aug version power bi app those features are not available like label , account bar ...etc , how to get those options
thanks Bas! how to edit Parameter then?
Click on the parameter table, then go to formula bar.. i do it in the video :)
great trick 👍🏻
Hope you can use some them
thanks, nice tricks
Thank you 😊
Really nice
Thanks a lot
My problem is my bar tooltip should change accordingly selected measures is that possible
You cannot choose a different custom tooltip. But you can use the parameter in the visuals that you show on the custom tooltip so that it shows the selected metric
@@HowtoPowerBI thank you so much for reply but I have like 4 pages almost 10 visual per page ,and each visual has different dimensions so it will be really hectic task to create custom tooltip to each
excellent
Thank you 😊
Hey Bas, I always watch your videos. I wish you would help me with this problem. The dataset is being pulled from SQL server but is too big to import to PBI, so I'm trying to use a parameter directly in power query so it only shows me the information I want. I manage to do this with direct query and the parameter value is passed from the PBI Dashboard through a slicer. It works really well, starts doing the query every time a new ID is passed but when I try to publish to PBI service it says "Your file was published, but disconnected. The report is not connected to one or more data sources. To connect, go to dataset settings or ask the dataset owner for help".
My best guess is that since I am using direct query, it doesn't have any data in the report. How can I use this report in power BI service?
Too big to import? How many rows/columns?
@HowtoPowerBI it's really really big. The query is big and complex that does a lot of joins. It's not made to bring all persons information at the same time. I've tried running the query without parameters just to see how much it would take and let it load for half an hour and it didn't even show the first row. It has all employees' history since the beginning of the company, and it's a big company, so it makes sense that it's a lot of records.. I dare to say millions.
Hi mate, I have seen this message before, and every single time was because of a non existing connection in the PBI service, I mean, in the desktop exist but not in the service yet.
Once I config all the gateways properly inside the dataset (now called semantic model), everything works just fine and the message never shows up again.
That message appears regardless whether it's import mode or direct query. Just means additional set up is required in service.
@Detka48 I have published other dashboards that used import query and that message DOES NOT APPEAR.
Super ❤
🤓💻 thx
Unfortunately only usable for measures and not normal columns
Thanks for this video @Howtopowerbi..
Why not just use new card visual?
? two completely different things
interesting but again, 30min videos and maybe x2 for implementation with lots und complexity for something trivial that should work out of the box.
Maybe time to switch to tableau then?
Back with a bang...