Dynamic chart value by clicking bar

Hi Anonymous,

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.

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.