Dynamic chart value by clicking bar

[jeongkim]

Hi,

Is there any way to get each Week's value when I click the week bars not being affecting Week slicer? 

I think Week slicer left selected 24 so whole page only shows week 24's value. 

that why if I click bar bottom such 22 or 23 then no values shown. 

can we make it dynamic not being affected by slicer? 

[v-pnaroju-msft]

Hi jeongkim,

We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi jeongkim,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi jeongkim,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Thankyou, @kushanNa, @rohit1991, and @danextian, for your responses.

Hi jeongkim,

We sincerely appreciate your inquiry through the Microsoft Fabric Community Forum.

Please follow the method outlined below to achieve dynamic chart selection without the Week slicer affecting it:

1. Load the sales dataset containing Date, Week, Region, Product, and Sales columns.
2. Create a disconnected table named Week_Disconnected.
3. Use Week_Disconnected[Week] in the slicer without relating it to the main sales table.
4. Build a bar chart using SalesData[Week] and SalesData[Sales].
5. Navigate to Format > Edit interactions, select the slicer, and set its interaction with the bar chart to None.
6. Create a measure named Selected Week Sales.
7. Add a card or table visual to display the Selected Week Sales measure.

Please find attached the screenshot and sample PBIX file for your reference:

We trust that the information provided will assist in resolving your issue. Should you have any further queries, please do not hesitate to reach out to the Microsoft Fabric Community.

Thank you.

[danextian]

Have you tried disabling the visual interaction between Week slicer and the column chart?

[rohit1991]

Hi @jeongkim,

You can’t get both behaviors with the same field, the slicer will always filter the chart. Best approach: remove the Week slicer or break the interaction between the slicer and the chart, so the chart remains fully clickable.

Heres How

Option 1: Remove or Decouple the Week Slicer

• Remove the Week slicer, or

• Make sure the bar chart visual does not interact with the slicer (use the Format tab > Edit interactions, set the slicer to “None” for the chart). This way, the bar chart will always show all weeks, and you can click any week to cross-filter the rest of the page.

Option 2: Use a Separate Week Table

• Create a separate “Week” table (unrelated to the model) just for the slicer or the chart.

• Use one for filtering, one for display, so the slicer selection doesn’t filter the chart visual.

[kushanNa]

Hi @jeongkim 

Have you tried to use the visual interaction feature? https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...