Product name and months on the same axis while revenue is on the other axis, is it possible?

[rickylee]

Hello,

At the moment, I have products as legend and each product is displayed in the belowed (LHS) chart on a monthly basis. For example, the longest bar displays the revenue of product A which is followed by product B...etc

However, it is not good for comparison of the same product. What I need is the yellow background ofthe diagram below(RHS). I want a productA to be display and all the monthly revenue relates to productA. Then productB follows etc
My drillthrough fails to do that, is there a way to do that?

Thanks,
Ricky

[rickylee]

Hi @v-frfei-msft,

This goes back to my original problem. The X-axis shows the Month which is right. But I have the following problem:
1. It does not show the name of my products (or bundles)
2. It displays the revenue of each product on a monthly basis which is logical. But is there a way to display like this:
We show the revenue of productA in Aug, Sept and Oct. Then, the revenue of productB in Aug, Sept and Oct... (An exmaple is yellow diagram when I initially stated my question)



Thanks,
Ricky

[v-frfei-msft · Accepted solution]

Hi @rickylee,

You can add two columns in the X-axis here.

For more details, please check the pbix as attached.

Regards,

Frank

[rickylee]

@sokg
Powerbi automatically removed the month and day. It does not allow me to add back.

Thanks,
Ricky

[sokg]

Do you use a calendar table???

If yes put year and then month (second level).

[rickylee]

@sokg
Hi,

It partially works but it shows the revenue in 2018 and does not allow me to drill down to monthly basis.



Thanks,
Ricky

[sokg]

At your first pic you had all date hierarchy.

At your second pic is only year hierarchy. That is your problem.

[sokg]

Hello @rickylee

Put product on axis and month on legend.

Hopefully this is what you are looking for!