Show YTD vs YTD SPLY in 100% stacked column chart

[Martin-Prague]

Dear experts, 

My requirement is following:

I should be able to select e.g. Q2'18 with once slicer and show in comparison between Q2'17 (Same period last year) side by side. Splitted by BRAND and on X axisis splitted by MARKETS (see the picture below).

Same period last year should be shown as another column.

See the pircture.. this is for BELGIUM.  Same for France, Italy,.....

view in EXCEL 🙂

I am working with measures.

Do you have any idea?

Kind regards,

Martin-Prague

[v-yulgu-msft]

Hi @Martin-Prague,

You could add multiple fields onto X-Axis. Here, you should add [Brand] and [Year-Quarter] columns to X-axis. Then, in chart visual, click the third drill down icon on the top left to locate to the bottom level.

Regards,

Yuliana Gu

[Martin-Prague]

Hello,

I want to be able to compare YTD vs YTD LY by COUNTRY  and BRAND (on legend). Than you can see visually the evolution in selected or TOP markets.

If I put the BRAND to X axis I am completly missing the comparison of shares in two diffrenet time periods.

Hope it clarifies my issue.

Kind regards,

Martin