PowerBi Comparing two data sets in clustered bar chart, where one data bar shall change with slicer.

[MuhammadImran]

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

[MuhammadImran]

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

[amitchandak]

@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-C...

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-...