Forum Discussion
Bal_Singh
Helper I
Helper IIs it possible to create a Bar Chart based on a filtered Table Visual?
I have a table visual which is filtered on a measure having values greater than zero. How could I use the filtered results to create a bar chart? Not sure if that is even possible but would be inter...
Bal_SinghHelper I
Helper IThank 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% |
