Pull data on Clustered column chart on fixed range say 6 months by selecting the a date from slicer.

[AmbajiRao]

I have one Clustered Column Chart 5 other table visuals and a date slicer in my report. What i need is while selecting date the table should filter data based on date as there are few delta fields exists but in Clustered Column Chart i need the data for last 6 months on month basis based on the date i selected in slicer.

Please let me know if i can use same slicer for both Table and Chart visuals, Also how to get last 6 months data based on the date i selected in slicer.

[v-micsh-msft]

Hi AmbajiRao,

Edited:

Please first check and see if the reply from matemusic in the following thread would help in your scenario:

http://community.powerbi.com/t5/Desktop/Show-last-13-months-based-on-user-single-slicer-selection/m-...

It is available to have one slicer working on both Table and Chart visuals. We could edit Visual Interactions through Power BI Desktop->Format->Edit Interactions:

For slicer to show last 6 month time range, currently I don’t think this is available. Please check my reply in the following thread:

Dynamic Display Last 12 Months in Visual According to Month Slicer

For a workaround, we may create a Year slicer, then take use of drill through function to check the month data.

Visual hierarchies and drill-down behavior

If any further help needed, please feel free to post back.

Regards

[AmbajiRao]

 Am still looking for the solution, Edit interactions is ok if the slicer does not exists but we need the data by selecting the  value in slicer. based on the slicer value selection last 6 months data should be displayed in the bar chart.