Last 6 months graph [Pbix attached]

[galbatrox9]

Hi Guys,

I have a date, sales and sales error tables. ( I have the sample file attached). I wanted to show a line and stacked column graph that showed sales for the last 6 months with a line that showed the sales error counts for the last 6 months too based on the months slicer.

I tried using this : https://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-pow...

PowerBi File

It works well if i just want to show Sales for last 6 months, but i cant seem to be able to connect the errors to that same graph because this method works by adding a year/month column into the data tables.

Can someone please help me find an alternative way?

PowerBi File

[Icey]

Hi @galbatrox9 ,

Is this problem sloved?

If it is sloved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey · Accepted solution]

Hi @galbatrox9 ,

Sorry to reply late. I made it. Hope this is what you want. This is my PBIX file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sapirmarko]

hi! this is exactly what I need!

how can I get your file, please? the link don't working

[Icey]

Hi @galbatrox9 ,

Based on my test, for the model you created, your two measures can only display in two visuals.

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[galbatrox9]

@Icey  i understand that. Is there an alternative though? Maybe new measures ?