Create ALL IN ONE Power BI Visual ✨| Show Previous Years, Forecast and YTD in a Single Visual

Many Times we get requirements to show Previous years, current year forecast and then cumulative Current year values, such features are not directly available with Power BI Native column cart or bar chart. In this video, we will create this visual without using any custom visualizations. Check it out.

Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric

Follow us on LinkedIn
@PowerBIHelpline

[sadiqabkr]

Very helpful video! Really amazing. Thanks for sharing.

[unnikrishnansanthosh]

extra ordinary, thank you for sharing

[viniciusferreira]

It helped me a lot! Thank you very much!

[edwinarchico]

This is really amazing, this is so helpful🎉

[ThinhLe-ehre]

thank you, it's very helpfull video.
But if turn to next year, is it auto change to 2024 is this year?

[omarbn]

Very nice, just wondering if it's possible not to show the months with blank YTD in the chart? Only months with value visible in the visual, thank you

[ajinkyaadhotre]

hey i didnt get the return expression at 4:09

[marawanmalek]

The period year column includes a string, so how does the comparison with the year integer from dimdate table

[ajinkyaadhotre]

Please help, why am i getting this error ? DAX comparison operations do not support comparing values of type integer with values of type Text.Consider using the VALUE or FORMAT functions to convert one of the values .

[ajinkyaadhotre]

Hi I am new to powerBI and i am unable to understand the DAX you have written, how do i learn those concepts ?

[ajinkyaadhotre]

Hey where do I get the data from ?
The one you used

[sadiqabkr]

I tried to implement, this is the error message I'm facing:
"A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed." Kindly assist. Thank you.

[vp]

Is this possible with Month and week number?