Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
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.
@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.
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.
@v-lid-msft I ended up doing this. I have multiple 'count for column for 0' measures though, so I had to have a slicer for each (around 10). Not ideal, but it got the job done.
I think you need a flag. create it has a column
Flag = IF (table[value] =0 ,"Zero Value","Non Zero Value").
You might need a bi-directional join, in case this a central/child/fact table and you want to filter parent/dimension table
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |