Dynamic columns in Clustered column chart

[Anonymous]

HI Team, 

Would like to explore the possibility if we can add/Create dynamic column in Clustered column chart . With matrix visual Its possible but Not able to add similar kind of column in other usual chart. 

Any idea if we want to create and add dynamic column for other charts , how it would be possible? 

scenario: 

Consider one slicer and Clustered column chart. 

when slicer is not selected than chart should display data based on Year and when slicer is filtered with some year than chart should display data based on quarters . 

Thanks

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

Such as amitchandak said , you could use feild parameter.

The result as follow:

Or you could use drill down.

when slicer is not selected than chart should display data based on Year and when slicer is filtered with some year than chart should display data based on quarters . 
There should be no way to automate this completely. You can consider both of these approaches.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I think field parameters can help

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

You have to select year too