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!
@Aquaelus19 күн бұрын
You are Truly a Inspiration for Creativity with Power BI. God Bless you
@HowtoPowerBI19 күн бұрын
😃 happy to hear that , thank you
@56ritikkrraj4018 күн бұрын
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'! ❤️
@scottwilliams67412 күн бұрын
I love this solution, Bas! Thanks so much for a new tool that I will use in every report!!
@JayCee902617 күн бұрын
@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
@D_Hoffmann_greenique17 күн бұрын
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!
@vladositto19 күн бұрын
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?
@HowtoPowerBI19 күн бұрын
So you dont want them in order of selection, but a custom sort order set by you?
@vladositto19 күн бұрын
@@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.
@vladositto19 күн бұрын
@@HowtoPowerBI And I would like at least to have the ability to see the grouping order through a label.
@naylord519 күн бұрын
@@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.
@jawadahmadehssan625117 күн бұрын
Thank you Bas, in fact I used this today to enhance the user experience when they wanted to switch between currencies.
@user-data_junkie19 күн бұрын
Baie dankie Bas! Your last point for the matrix, you can also add ;;; in the format on top to make the numbers disappear.
@HowtoPowerBI19 күн бұрын
that would leave the column visible though ,.. but without any values visibly showing in it
@user-data_junkie19 күн бұрын
@@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
@TheSandywarrior14 күн бұрын
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!!
@HowtoPowerBI13 күн бұрын
Better late than never?! 😁
@alansnyder656511 күн бұрын
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.
@tejaswijavvadi404616 күн бұрын
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
@sanderk.30217 күн бұрын
really nice video. these are the typical issues I was struggling with. Great stuff
@MoeBig5017 күн бұрын
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.
@abdel744319 күн бұрын
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.
@TheRealOrangeAde19 күн бұрын
Thanks Bas, informative as always 🙂
@HowtoPowerBI19 күн бұрын
Thx for watching again 😃
@arbazahmad717714 күн бұрын
Excellent.... nice trick 👌.... thanks for sharing 🎉
@wilconagtzaam58719 күн бұрын
Excellent, as always! 👍
@HowtoPowerBI19 күн бұрын
dankjewel Wilco!!! 😁 groetjes
@perfectionist662419 күн бұрын
Thanks Bas... You are the Boss ❤ Lots of blessings for you.... Amazing as always... Superb outstanding content😊 ❤❤😊
@HowtoPowerBI19 күн бұрын
thank you so much, appreciate the nice words :D
@AizenDoza17 күн бұрын
You are the best 🕶! 🤩🤩🤩
@HowtoPowerBI17 күн бұрын
probably not :P but thx for the compliment!
@ugochukwunwasuruba135618 күн бұрын
Amazing Very informative. Thanks for sharing.
@HowtoPowerBI18 күн бұрын
Glad it was helpful!
@aliceszuts479119 күн бұрын
Super, 👍 you are the best! 👌
@HowtoPowerBI19 күн бұрын
Thx Alice
@tubeitz18 күн бұрын
super! thanks for sharing
@Vaibhav-o7c18 күн бұрын
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.
@theoth3r4 күн бұрын
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.
@tristain_music18 күн бұрын
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 :)
@HowtoPowerBI18 күн бұрын
lol, yea I've seen a yt video that did that ... maybe one day ;) .. first have to gather some data 😅
@craniumnr19 күн бұрын
Just amazing!
@Aegus15 күн бұрын
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.
@vishalnasre125114 күн бұрын
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 ?
@papibaquigrafo8219 күн бұрын
Very good, as always!
@HowtoPowerBI19 күн бұрын
😁🤓💻
@titoexample19 күн бұрын
thanks, nice tricks
@HowtoPowerBI19 күн бұрын
Thank you 😊
@tonyminglu19 күн бұрын
I've been using bookmark buttons to achieve a very similar result. Would you recommend bookmark buttons or parameters?
@Detka4819 күн бұрын
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.
@KhangTran301119 күн бұрын
great trick 👍🏻
@HowtoPowerBI19 күн бұрын
Hope you can use some them
@Myriam-sx5bf18 күн бұрын
Really nice
@HowtoPowerBI18 күн бұрын
Thanks a lot
@mogarrett304519 күн бұрын
excellent
@HowtoPowerBI19 күн бұрын
Thank you 😊
@RamakrishnaR-tl6yy19 күн бұрын
in aug version power bi app those features are not available like label , account bar ...etc , how to get those options
@gayatrilshinde156018 күн бұрын
My problem is my bar tooltip should change accordingly selected measures is that possible
@HowtoPowerBI18 күн бұрын
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
@gayatrilshinde156018 күн бұрын
@@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
@shubhabratadey19 күн бұрын
Back with a bang...
@ramakrishnaravula435019 күн бұрын
Super ❤
@HowtoPowerBI19 күн бұрын
🤓💻 thx
@helloworldtt927119 күн бұрын
thanks Bas! how to edit Parameter then?
@HowtoPowerBI19 күн бұрын
Click on the parameter table, then go to formula bar.. i do it in the video :)
@Addifyablee5 күн бұрын
Unfortunately only usable for measures and not normal columns
@djender19 күн бұрын
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?
@HowtoPowerBI19 күн бұрын
Too big to import? How many rows/columns?
@djender19 күн бұрын
@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.
@naylord519 күн бұрын
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.
@Detka4819 күн бұрын
That message appears regardless whether it's import mode or direct query. Just means additional set up is required in service.
@djender18 күн бұрын
@Detka48 I have published other dashboards that used import query and that message DOES NOT APPEAR.
@davitlomadze983112 күн бұрын
Why not just use new card visual?
@HowtoPowerBI12 күн бұрын
? two completely different things
@Vaibhav-o7c18 күн бұрын
Thanks for this video @Howtopowerbi..
@hyperadapted5 күн бұрын
interesting but again, 30min videos and maybe x2 for implementation with lots und complexity for something trivial that should work out of the box.