Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |