Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Hide Legend/Axis on visual

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.

working.JPGnotworking.JPG

 

How can I solve this? 

 

Best Regards

3 REPLIES 3
JosefPrakljacic
Solution Sage
Solution Sage

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

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.