Thank you! but when I open the overlaying chart in focus mode after grouping them, only one of them appears. Is there a way to have both the chart view together in focus mode?
I hope they could add this a native functionality since it would really be helpful in comparing data. In scenarios like this, I miss working in Excel. 😅
@@kuuuyajim actually it was not mentioned in the blog. I only saw Gustaw Dudek’s linkedin post about this feature. I immediately used it in my actual project… so helpfuk
Great video! Is it somehow possibile to show the data labels for previous and current month? Like not only the variance, but also the value representing the height of the bars.
I am a beginner and my chart isn't working as expected. When I select a specific month (for example, November 1997), it only displays the sales for that month and not the previous month's sales. However, when I remove the date filter, it shows both - the current and previous month's sales. Could you please explain why the calculation for the previous month is affected by the date filter?
I am facing The syntax for 'RETURN' is incorrect. (DAX(DIVIDE(Risk_Assessment[Risk score current],Risk_Assessment[Prv. risk score]) - 1RETURN)). problem while creating a upward or downward trend
Warning: You have to be overly extremely careful when editing this type of overlapped charts. A single difference in font type or font size or a single different setting in the column charts can make the values of the "invisible axis chart" differ from the axis you see.
Nicely done! That's elegant.
Excellent work. Very impressive. Thank you
What a great idea! Thank you so much!
Thank you! but when I open the overlaying chart in focus mode after grouping them, only one of them appears. Is there a way to have both the chart view together in focus mode?
I hope they could add this a native functionality since it would really be helpful in comparing data. In scenarios like this, I miss working in Excel. 😅
it's available in 2024 february update - so it's finally natively supported
I overlooked the blog update. 😅
@@kuuuyajim actually it was not mentioned in the blog.
I only saw Gustaw Dudek’s linkedin post about this feature.
I immediately used it in my actual project… so helpfuk
Great video! Is it somehow possibile to show the data labels for previous and current month? Like not only the variance, but also the value representing the height of the bars.
use custom labels
I am a beginner and my chart isn't working as expected. When I select a specific month (for example, November 1997), it only displays the sales for that month and not the previous month's sales. However, when I remove the date filter, it shows both - the current and previous month's sales. Could you please explain why the calculation for the previous month is affected by the date filter?
How do i add a legend to make it clear that they grey is a previous week and the current is blue ?
Is there any way to add label to show which color is current year sales vs previous year sales
nice video. But it very difficult to this with a multi color backround. Any tips on that?
how we would calculate max axis if our chart would have as x axis dates and y axis one with monthly sales and the other last year same month ?
is it possible to show the data labels in bar charts, like can we show percentage on labels as well?
I am facing
The syntax for 'RETURN' is incorrect. (DAX(DIVIDE(Risk_Assessment[Risk score current],Risk_Assessment[Prv. risk score]) - 1RETURN)). problem while creating a upward or downward trend
well done Fernan!
Thank you Fernan
Amazing, Thanks so much
excellent video and will try to implement
Excellent ideas, thanks for posting, i am looking the same to present..👌👍
how about creating this chart type based on last year same month?
super! i'm looking for overlap bar
How does this work in focus mode ?
What if you focus or make the chart full screen, will it be the same visual??
just one probably
nice example. Thanks
How do I export it as one?
Warning: You have to be overly extremely careful when editing this type of overlapped charts. A single difference in font type or font size or a single different setting in the column charts can make the values of the "invisible axis chart" differ from the axis you see.
Great
This is really cool, however legends are wenr off. What is the way to keep the legend on for current amd last year data
How to solve Data Table showing just 1000 rows
🎉
Outdated, i can only put 1 y axis data. WTF Microsoft?!?