Forum Discussion
PowerBi Comparing two data sets in clustered bar chart, where one data bar shall change with slicer.
Dear all,
I am comparing two data sets in clustered bar charts. One let’s say "Target" for a year and other "Achievement" with cumulative monthly figure. The target is static number for whole year, whereas achievement is progressing every month.
So, I want to compare the data by changing month in slicer, but I want only the achievement bar to change. Would it be somehow possible?
Thanks
Imran
2 Replies
- amitchandak
Super User
MuhammadImran ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
See if these can help
Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400
Power BI Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798
Thanks amitchandak
Attached are snaps of sample data and of the graph.
In graph, "Gray" bar is "Target" whereas "Orange" bar is achievement against target in Jan, Feb and March. I want it to be in one graph and add a slicer with names of Months (lets say comun headers in this case) in which when we select a month, it shall just change the orange bar.
Best
Imran
