user wants to see four charts in one Report - dynamic

[ashmitp869]

Hi,
I have a user requirement where user wants to see four charts in one Report

The Project 1 has 4 discipline 

Rock Excavation
Rock Bolts
Mesh
Shotcrete

Project 2 can have
Grouting
Mesh Roof.

1. Is it possible to achieve ?
Sample file 
https://github.com/suvechha/samplepbi/blob/main/p6.pbix

2. The Discipline Type - if selected Grouting for project 2 , when I change the project 1 - it still selected the Grouting.

though the Project 1 don't have that discipline

Thanks

[suparnababu8]

Hi @ashmitp869 

If understood your requirement correct, hope this is your expectation. 

If you want to achieve this, you can use Small multiple option in Power BI desktop.

Pls let me know your thoughtes on this.

Thank you!!

[ashmitp869]

Yes this is what I am expecting

[suparnababu8 · Accepted solution]

Hi @ashmitp869 

Attached the pbix file.Pls go through it.

Thanks!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[ashmitp869]

Hi @suparnababu8 
Is it possible to show each month data i.e 
Jan 2025 Feb 2025 Mar 2025 until Mar 2026 in this above graph ?

[Ashish_Mathur]

Hi,

To the X-axis of the Small multiples graph, drag Year and Month from the Calendar table.

[ashmitp869]

Hi @Ashish_Mathur 
I won't want to do that as the P6QtyWeekly Date field is not linked to Calendar Date table.
Because , the user requirement is to show all Data even the user select any date field. 
1. Show full data from beginning to end.
2.The data starts from Jan2025 until Mar2026 - the user wants every month data to show on the chart.
i.e Jan 25 , Feb 25 , Mar 25 .....Mar 26.

Is this achievable ?
sample file
https://github.com/suvechha/samplepbi/blob/main/p6.pbix


@suparnababu8 

[ashmitp869]

Hi @suparnababu8 
Thanks for the solution. But the chart showing for all projects even I select 
SYD038 - 003 it is showing Data of SYD038-002

Please assist .
Thanks