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!
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.
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 ..
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"
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...
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!
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.
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?
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%
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.
🤯🤯🤯 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.
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 !! )
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.
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
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
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.
@@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.
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!
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
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!
For dedicated visual designers, this is perfect ❤ No complaints about the title, some people are so petty!
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.
This might be your best work yet to be honest...this is SO clean. So useful. Thank you for posting!
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 ✌️🫣
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???
How does the conditional formatting on axis value colors work - had no success with it, was expecting to work like bar colors 🤷♂
3:30 how do you put your measures in a subfolder like that?
You can name a folder with a backward slash folder\subfolder
🔝 as usually!
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!!
from where we can download the data set ?
download link is in the description
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"
That’s nuts Bas. You’re definitely some kind of wizard.
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?
I’ve been thinking of doing something similar for weeks! Awesome timing for this video
Impressive as always!
I wish you could put on a 1hr training session for my department.
Absolutely brilliant!!
This is so creative and useful! 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
Top notch creativity.
Crazy stuff... thx for sharing!!
💻🤓
That's fantastic. It is like wavering the wand 🤩
That's quite impressive. Thank you for sharing and making it easy to follow
This is really great! Amazing content
great work! love it
Insane creativity
Very clever, thanks for sharing.
😎✌️
Soo cool. You are very creative.
Man, you really think out of the box to create visuals. Thanks to share
Wow! this is great! I will adopt it in my tables / charts. Thanks a lot!
Amazing!
Impressive trick.
You are very intelligent, I hope I be just 50% of you ❤
That’s superb Bas! Well done sensei!
Thanks Ruslan!!!
Great work, Bas! It's a beautiful chart, but my goodness what a headache it is to build.
🤣 love the comment
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...
Amazing 👏... thanks for sharing 🎉
awsome !! thank you for your sharing 👍
Thanks for watching ✌️🔥
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
As usual Bas, mind blowing and so interesting. Thanks for always smiling and putting such a good energy on all your videos 😊
you are greAt
Total gamechanger 🤯 you could do something like this for same month / same day last year?
Absolute genius!
✌️😎🤩
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.
amazing, that looks so beautiful ❤❤
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?
Drill up and drill down I wanted the most ❤
Thanks Bas you are amazing 🎉
❤️🔥
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!!
🤯 Mind Blown 🤯 - Thanks for sharing 👍👍
Thanks for watching! 🚀😎
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.
Muy buena aportación.
Gracias
✌️thx for watching
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
Thank you very much. Love you ❤
🤩✌️
Very smart!
🚀😎✌️ thanks for watching
Wow ❤
Not all heroes wear capes
this is so good :) thanks for also showing the measures :)
Sure! Glad you like ot
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
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
with this aren't we messing with actual sales values ? and the Y axis
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%
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:)
You must have followed the wizard school of data vizualisation....🤯🤯🤯
✌️🔥🤣 yes called datatraining 🚀
🤯🤯🤯 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.
Creative
Thanks!
OMG - never would have guessed how you will do it in a million years - kickass out of the box thinking! ******** amazing!!!
Nice nice nice
AHHh more bookmarks when DAX should be what drives the hierarchy up/down. but cool hack none the less!
Bas I don't know which country you are from, but your visuals belong in your national art museum!
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 !! )
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.
It's a clever technique, but from a professional developer's perspective, it may be challenging to sustain over time.
pretty tricky skill
✌️🔥🚀
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
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
Power Bi artists 😅
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 😅
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.
@@In_a_state don't hate the player, hate the game
🤣🫣
It’s surely not that deep …
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 🔥