Forum Discussion
Resolver IDisplay result based on selected Category
kilala , if these are row values of a column, You can create a slicer with select all. And the Choose orientation as horizontal https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive
Solution SupplierkilalaYou can use slicer instead of shapes to filter values. Also, you can skip "ALL STATUS" in the filter value if it's not required at all, since unselecting any slicer value will automatically show all data.
Presuming you will doing some calculation since your data is in fact table, I have created a sample data to answer your question. Please find below:
Data:
Showing sum of all values when no filter is selected:
Showing only values for Open status:
DAX measure used for this calculation:
---------------------------------------------------------------------------------
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search. Thank you !