Bas, you have taught me so much since I've started watching your videos. I just want to thank you! Also, have you searched the 'Get more visuals' section? I found a version of this long ago called, 'Line and Stacked Column Chart with Table'. I may not be as visually pleasing as your work-around, but if someone is just looking for a quick and easy visual, this may work. Thanks Again for all you've done for Power BI!
Microsoft really needs to just implement a solution for this. What you have here that is far more complex than it should be to achieve. I could sit here and look at PBI for days and never have thought of this. Well done. Microsoft needs to pay attention to things like this.
Nice workaround Bas. What every power bi visual needs is the correct color transformation from desktop to pbi service. Dashboard Design in Service feels like waterboarding ..
I implemented a similar solution before you posted this video, with the additional complexity that there are breaks in the data - and I wanted Power BI to interpolate and "join the dots" both in the "native" frequency and in the other levels of the hierarchy. As you know Power BI doesn't interpolate (in "categorical" mode, not "continuous", as I had to display custom time labels on the x-axis). There are different ways to do this, I opted to show the previous value (for that level of aggregation) for when there is a gap, but potentially you can actually figure out the equation of the straight line between the start and end known values (beware, not the actual data, but its calculated aggregated start/end values at the different levels of the hierarchy) and make Power BI to draw a nice upwards/downwards line.
Thank you for another great video! I hate that it needs so much tweaking and creation of multiple measures, but I love the creativity you put into making user-friendly and intuitive solutions that looks and works so well. I hope the Power BI developers watch your videos. 🙂 Keep up the good work!
Perfect! Love this visual! You state that this is not yet available by default, however, do you think it will be possible to create this using a charticulator visual?
Bas, your idea is not bad, but from my point of view, it takes a lot of time, plus: you need a lot of DAX, if you change the KPIs, you need to redo the measures, you use the IF function, not good for performance...I use a very simple solution: most of the graphic visuals bring the alternative of the "Show as a Table"...and you have all what you need there. Not so formatted as you have it but simple, quick and with really 0 effort and standard. You change the measures, and immediately you have the full data working. If you want it with a nice format, you create a Tooltip with all the features you like....as I said at the very beginning VERY good idea, but depends on the Customer, what they want, what will they pay for the solution...
This is mind-blowing. A lot of work, so would use it only if I know the client is really really going to use this chart for their business purposes but still a lot of tricks inside this one video. Thanks for sharing.
Nice, as all presentation, values belove first month or quarter sholud be empty, we dont have values for compare, maybe in their place put thr information "∆ PM" and "∆% PM"
wow... just WOW.... you honestly make something so complicated look so easy... and although we all agree it should just be there "out of the box"... you are truly an inspiration in creating "outside of the box" workarounds !! #LEGEND ( so happy and positive about it too !! )
Thats a great work around that most pbi developers were looking for. Are we able to create colums 2024 and 2023 rather than lines? And below to create custom measures?
You are not a wizard. You are a freakin' warlock! How on earth can you explain how you came to this solution? So, I decided two things after watching your presentation. Firstly, this is going to be expensive; If client wants it, they pay! Secondly, I need to go to the crossroads cuz I'm swapping my blues skills or I want a refund. On a serious note. Baz. This is astounding. A lot of hard work went into this offering. It is the sort of thing I look for to know I am confident that what is possible in PBI and what is exceptional - and that they are so far apart. It does astound me that Microsoft have not provided this functionality when it is there in EXCEL. And, no, TABLE view does not cut it. My respect for MS stops me from being too upset, and I am paid for what I do with their products so...reality check. Thank you so much for this Bas.
🤯🤯🤯 how do you find out these solutions, it's really amazing. Well, the visual is not so great when displays the data by yeat, however it's not something too relevant. Excellent job.
Next Video Suggestion: I work in huge data, for my 1 year of data, the pbix is already over 500MB, I want to continue with same file to have future months data as well. All my data is in xlsx format, and locally saved on my One drive. * Any tips & tricks to have the Data managed well & to work on file faster, which currently due to size its too slow. Your help is appreciated. Cheers!
Creating lots of dax measures just to achieve this visual may not be the best way to spend my time when I have a big model with lots of KPIs or measures to visualize
Hey bas, i am working on same kind of problem, one additional requirement is on y axis i need bar chart(values can go upto 1000) and on secondary y axis we have results which can vary from 1 to 100%
Hi could you please help me with this scenario : i have 20 measures of different currency data type based on region slicer selection i have show respective currency measure suppose if i select dubai option from slicer then in y axis will be in arabic currency if US then dollar i created a parameter for all this measures and used that parameter in bar chart now if we wont select any option in slicer then all measures will be seen but without any selection in slicer we need to default US measure dollar in Y axis
Scenario 1.calendar table 2. Table1 created in m query using some.condition 3. Need to create table2 using dax where date is selected in slicer should produce a table with records from selected date till the max date Eg..List of dates for an year If I select 09/14/2025 it should give table result from 14 sep 2025to 31st dec 2025 and so on I am.facing problem where I am storing the selectedvalue date in a variable it diaplays correctly on the card but when I try to create table using dax it passes it as null Filter condition is loadstartdate>=selectedvalue (date) Note: Table 2 is exact copy of table1 just have filtered rows based on selecteddate till max date
@@HowtoPowerBI "Best way to make a combo chart & table in Power BI" or something. What irks me is that the title is just so false, too general, pretty ridiculous.
@HowtoPowerBI personally I don't like it cause if I'm searching for that video on combo charts, it's not very obvious this was the one I wanted to reference
I feel like I want an Adobe / Microsoft merger. If they actually wanted to push out the best product to be #1, I would welcome it minus the impending apocalypse that would happen from a merger of such scale.
Dude! Enough with the abuse of dummy measures and workarounds. It is disgusting and a bad practice. What the hell are you even teaching? Find something else for content.
My report development process for experienced developers 🚀🔥✌️
datatraining.io/powerbidesigntransformation
Incredibly creative to a solution that Microsoft shouldn't need you to have done. Very well done
Wow the best artist of Microsoft Power BI, I don't know how you managed to find this solution and it must take you ages. THE POWER BI MASTER!
This might be your best work yet to be honest...this is SO clean. So useful. Thank you for posting!
For dedicated visual designers, this is perfect ❤ No complaints about the title, some people are so petty!
I’ve been thinking of doing something similar for weeks! Awesome timing for this video
Bas, you have taught me so much since I've started watching your videos. I just want to thank you! Also, have you searched the 'Get more visuals' section? I found a version of this long ago called, 'Line and Stacked Column Chart with Table'. I may not be as visually pleasing as your work-around, but if someone is just looking for a quick and easy visual, this may work. Thanks Again for all you've done for Power BI!
Brilliant, Bas! 👍 This should hold them off a few seconds longer before asking how they can download the data to Excel. 😅
kkkkkkkkk Please... how is it possible... kkkk???
Microsoft really needs to just implement a solution for this. What you have here that is far more complex than it should be to achieve. I could sit here and look at PBI for days and never have thought of this. Well done. Microsoft needs to pay attention to things like this.
This is so creative and useful! Thank you so much!
Nice workaround Bas.
What every power bi visual needs is the correct color transformation from desktop to pbi service. Dashboard Design in Service feels like waterboarding ..
Yeah also a good point ✌️🫣
That's quite impressive. Thank you for sharing and making it easy to follow
Impressive as always!
Every time I see there is a new video notification from you I already know it will be an excellent content that I must watch... thank you so much!!
That is really cool. I think I'm going to attempt this for my meeting next Friday. Keep up the amazing work
Wow! this is great! I will adopt it in my tables / charts. Thanks a lot!
Man, you really think out of the box to create visuals. Thanks to share
As usual Bas, mind blowing and so interesting. Thanks for always smiling and putting such a good energy on all your videos 😊
Absolutely brilliant!!
Crazy stuff... thx for sharing!!
💻🤓
Hey Bas, I'm trying to do this char in my Power BI report and if I add year slicer into page then I lost RowLbl1Pos and RowLbl2Pos label
I implemented a similar solution before you posted this video, with the additional complexity that there are breaks in the data - and I wanted Power BI to interpolate and "join the dots" both in the "native" frequency and in the other levels of the hierarchy. As you know Power BI doesn't interpolate (in "categorical" mode, not "continuous", as I had to display custom time labels on the x-axis). There are different ways to do this, I opted to show the previous value (for that level of aggregation) for when there is a gap, but potentially you can actually figure out the equation of the straight line between the start and end known values (beware, not the actual data, but its calculated aggregated start/end values at the different levels of the hierarchy) and make Power BI to draw a nice upwards/downwards line.
3:30 how do you put your measures in a subfolder like that?
You can name a folder with a backward slash folder\subfolder
This is really great! Amazing content
Thank you for another great video. I am having difficulty when applying the 'RowValue1Text' measure, the calculation value shows zero.
That's fantastic. It is like wavering the wand 🤩
Very clever, thanks for sharing.
😎✌️
🔝 as usually!
Thank you for another great video! I hate that it needs so much tweaking and creation of multiple measures, but I love the creativity you put into making user-friendly and intuitive solutions that looks and works so well. I hope the Power BI developers watch your videos. 🙂 Keep up the good work!
Thanks 😊 I agree, many times obviously needed functionalities are a pain to make possible dummy x dummy
That’s nuts Bas. You’re definitely some kind of wizard.
That’s superb Bas! Well done sensei!
Thanks Ruslan!!!
Top notch creativity.
great work! love it
awsome !! thank you for your sharing 👍
Thanks for watching ✌️🔥
Amazing 👏... thanks for sharing 🎉
Perfect! Love this visual! You state that this is not yet available by default, however, do you think it will be possible to create this using a charticulator visual?
this is so good :) thanks for also showing the measures :)
Sure! Glad you like ot
Bas, your idea is not bad, but from my point of view, it takes a lot of time, plus: you need a lot of DAX, if you change the KPIs, you need to redo the measures, you use the IF function, not good for performance...I use a very simple solution: most of the graphic visuals bring the alternative of the "Show as a Table"...and you have all what you need there. Not so formatted as you have it but simple, quick and with really 0 effort and standard. You change the measures, and immediately you have the full data working. If you want it with a nice format, you create a Tooltip with all the features you like....as I said at the very beginning VERY good idea, but depends on the Customer, what they want, what will they pay for the solution...
🤯 Mind Blown 🤯 - Thanks for sharing 👍👍
Thanks for watching! 🚀😎
Soo cool. You are very creative.
amazing, that looks so beautiful ❤❤
Insane creativity
Muy buena aportación.
Gracias
✌️thx for watching
Drill up and drill down I wanted the most ❤
Thanks Bas you are amazing 🎉
❤️🔥
You are very intelligent, I hope I be just 50% of you ❤
Great work, Bas! It's a beautiful chart, but my goodness what a headache it is to build.
🤣 love the comment
Thank you very much. Love you ❤
🤩✌️
How does the conditional formatting on axis value colors work - had no success with it, was expecting to work like bar colors 🤷♂
This is mind-blowing. A lot of work, so would use it only if I know the client is really really going to use this chart for their business purposes but still a lot of tricks inside this one video. Thanks for sharing.
Thanks for watching and for the encouragement:)
Nice, as all presentation, values belove first month or quarter sholud be empty, we dont have values for compare, maybe in their place put thr information "∆ PM" and "∆% PM"
from where we can download the data set ?
download link is in the description
Amazing!
Nice Tutorial, thank you very much!👌
Unfortunetly nothing happens when I use the put the Labels on the Y-axis. - Any Suggestions? Thank you guys!!
Thanks a zillions - this is so very huge for my level, but would definitely try it on my work for sure in coming days. ❤❤
Thanks for watching hope you can use it
I wish you could put on a 1hr training session for my department.
in my case accuracy label name is coming on the same month line not sure what missed
Total gamechanger 🤯 you could do something like this for same month / same day last year?
Is this possible to do if you want ALSO just have a normal combo chart at top? With a table below ?
Absolute genius!
✌️😎🤩
OMG - never would have guessed how you will do it in a million years - kickass out of the box thinking! ******** amazing!!!
You must have followed the wizard school of data vizualisation....🤯🤯🤯
✌️🔥🤣 yes called datatraining 🚀
wow... just WOW.... you honestly make something so complicated look so easy... and although we all agree it should just be there "out of the box"... you are truly an inspiration in creating "outside of the box" workarounds !! #LEGEND ( so happy and positive about it too !! )
Thats a great work around that most pbi developers were looking for. Are we able to create colums 2024 and 2023 rather than lines? And below to create custom measures?
Impressive trick.
You are not a wizard. You are a freakin' warlock! How on earth can you explain how you came to this solution?
So, I decided two things after watching your presentation. Firstly, this is going to be expensive; If client wants it, they pay! Secondly, I need to go to the crossroads cuz I'm swapping my blues skills or I want a refund.
On a serious note. Baz. This is astounding. A lot of hard work went into this offering. It is the sort of thing I look for to know I am confident that what is possible in PBI and what is exceptional - and that they are so far apart.
It does astound me that Microsoft have not provided this functionality when it is there in EXCEL. And, no, TABLE view does not cut it. My respect for MS stops me from being too upset, and I am paid for what I do with their products so...reality check.
Thank you so much for this Bas.
Love the videos but dislike the clickbait. I'd like to know more about the content of the video based on the title. Keep up the good work!
I think this option should be there by default, so not so sure what is misleading here
Wow ❤
🤯🤯🤯 how do you find out these solutions, it's really amazing. Well, the visual is not so great when displays the data by yeat, however it's not something too relevant. Excellent job.
Bas I don't know which country you are from, but your visuals belong in your national art museum!
you are greAt
Next Video Suggestion:
I work in huge data, for my 1 year of data, the pbix is already over 500MB, I want to continue with same file to have future months data as well.
All my data is in xlsx format, and locally saved on my One drive.
* Any tips & tricks to have the Data managed well & to work on file faster, which currently due to size its too slow.
Your help is appreciated. Cheers!
@Bas @HowtoPowerBI
Any tips & tricks to have a work around better on huge data set would be helpful.
AHHh more bookmarks when DAX should be what drives the hierarchy up/down. but cool hack none the less!
with this aren't we messing with actual sales values ? and the Y axis
Creating lots of dax measures just to achieve this visual may not be the best way to spend my time when I have a big model with lots of KPIs or measures to visualize
Not all heroes wear capes
Creative
Thanks!
Hey bas, i am working on same kind of problem, one additional requirement is on y axis i need bar chart(values can go upto 1000) and on secondary y axis we have results which can vary from 1 to 100%
Nice nice nice
Hi could you please help me with this scenario :
i have 20 measures of different currency data type based on region slicer selection i have show respective currency measure suppose if i select dubai option from slicer then in y axis will be in arabic currency if US then dollar i created a parameter for all this measures and used that parameter in bar chart now if we wont select any option in slicer then all measures will be seen but without any selection in slicer we need to default US measure dollar in Y axis
Scenario
1.calendar table
2. Table1 created in m query using some.condition
3. Need to create table2 using dax where date is selected in slicer should produce a table with records from selected date till the max date
Eg..List of dates for an year
If I select 09/14/2025 it should give table result from 14 sep 2025to 31st dec 2025 and so on
I am.facing problem where I am storing the selectedvalue date in a variable it diaplays correctly on the card but when I try to create table using dax it passes it as null
Filter condition is loadstartdate>=selectedvalue (date)
Note: Table 2 is exact copy of table1 just have filtered rows based on selecteddate till max date
Very creative solution, but I hate these kind of titles.
Better suggestion?
@@HowtoPowerBI "Best way to make a combo chart & table in Power BI" or something.
What irks me is that the title is just so false, too general, pretty ridiculous.
🤣🫣
It’s surely not that deep …
@HowtoPowerBI personally I don't like it cause if I'm searching for that video on combo charts, it's not very obvious this was the one I wanted to reference
It's a clever technique, but from a professional developer's perspective, it may be challenging to sustain over time.
Power Bi artists 😅
pretty tricky skill
✌️🔥🚀
I feel like I want an Adobe / Microsoft merger. If they actually wanted to push out the best product to be #1, I would welcome it minus the impending apocalypse that would happen from a merger of such scale.
You so cute, you know that 😅
Dude! Enough with the abuse of dummy measures and workarounds. It is disgusting and a bad practice. What the hell are you even teaching? Find something else for content.
what do you eat to achieve this result? 😂it's brilliant 🔥
Very smart!
🚀😎✌️ thanks for watching