Forum Discussion
Slicing a visual by a count measure from another visual
I have a table with some values set to 0. I also have a bar chart that has 10 calculated measures that count each columns total of zeros. When I select one of these calculated measures on the bar chart, the other visuals do not update to the values that only have 0.
I understand there are some issues with slicing by a calculated measure, but is there any workaround for this?
Here is what one of those calculated measures looks like:
Hi Anonymous ,
Do you want to click on the B bar and left table visual left only the row that column=0 and category = 0? When you click the B bar, it actually give a filter that category=B to the table visual.
We suggest that you can use the slicer visual and put the column field.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- amitchandak
Super User
Anonymous wrote:. When I select one of these calculated measures on the bar chart, the other visuals do not update to the values that only have 0.
Do you want to use this calculation as a filter?
amitchandak wrote:
Anonymous wrote:. When I select one of these calculated measures on the bar chart, the other visuals do not update to the values that only have 0.
Do you want to use this calculation as a filter?
Yes. I would like for it to update the table visual that I have to contain only the values that contain 0.
v-lid-msftCommunity Support
Hi Anonymous ,
Do you want to click on the B bar and left table visual left only the row that column=0 and category = 0? When you click the B bar, it actually give a filter that category=B to the table visual.
We suggest that you can use the slicer visual and put the column field.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
