Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hello all!
I have a measure to get the SUM of worked hours of a timesheet.
WORKED HOURS = IF(HASONEFILTER(ResourcesTab[Name]);SUM('SA Timesheet'[Hours]);"")
I'm using HASONEFILTER because I have a slicer to select the Resource, and while there's nothing selected, I want to show nothing in my card.
But now I want to create a visual to show the amount of hours by project.
When I select a name, the visual works fine. But when nothing is selected, I still getting the legend/axis info.
How can I solve this?
Best Regards
Hey @Anonymous ,
here you can find a explanation how to hide a visual based on selection.
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others
Have a nice day!
BR,
Josef
Graz - Austria
HI @JosefPrakljacic, thanks for the fast reply.
But the problem with this method is that I lose the option to filter by graph. At first I would like to have that possibility yet. :S
Hey @Anonymous,
would you mind to explain in more detail what you actually want to achive I currently don't have a clue.
BR,
Josef
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |