Forum Discussion
Helper IIs it possible to create a Bar Chart based on a filtered Table Visual?
Super UserHi Bal_Singh
Yes, you can create a bar chart based on the same filtered data as your table visual. Since you cannot directly link a bar chart to a table visual's output, you can achieve this by applying the same filters to the bar chart:
-
Use the Same Measure Filter:
- In your bar chart, add the measure you're using in the table visual.
- Apply a visual-level filter to the bar chart by dragging the measure into the Filters on this visual pane.
- Set the filter condition to show values greater than zero, matching the table visual's filter.
-
Ensure Consistent Filtering:
- If your table visual uses slicers or page-level filters, make sure the bar chart is also influenced by these filters.
- This keeps both visuals in sync, displaying the same filtered results.
By applying identical filters to both visuals, your bar chart will reflect the filtered data from the table visual.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Bal_SinghThank you VahidDM ,
I already tried this but unfortunately did not work. The bar chart still calculates values unfiltered even though I applied the same 'measure' filter on the visual as you mentioned above.
Illustrated below. The bar chart keeps showing 100% despite the filter whereas I expect 56% whic is based on the filtered visual (Table2):Table 1 Account ID Opening Balance Withdrawal Withdrawal % of Opening Balance ABC 999 555 56% XYZ 0 444 TOTAL 999 999 100% Table 2 - Filtered on Opening Balance > 0 Account ID Opening Balance Withdrawal Withdrawal % of Opening Balance ABC 999 555 56% TOTAL 999 555 56%