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

Dinamic Tooltip Title

Hello 
I have created the Dax script below which changes the title of a reporting tooltip dynamically, however, if I have a category as "blank", there is no title being displayed at the moment.
Is it possible to change the script below to show the information "No record available".
 
ToolTip_Tile =
VAR SelectedMainCategory =
IF ( HASONEFILTER ( Dataset[ Cateogry] ), TRUE, FALSE )
VAR SelectedLocation =
IF ( HASONEFILTER ( Dataset[Location] ), TRUE, FALSE )
VAR MainCategory =
SELECTEDVALUE ( Dataset[ Cateogry], "Select Category" )
VAR Location =
SELECTEDVALUE ( Dataset[Location], "Select Location" )
RETURN
IF ( SelectedMainCategory, MainCategory, IF ( SelectedLocation, Location))
1 ACCEPTED SOLUTION
Anonymous
Not applicable

[ToolTip Tile] =
    SWITCH ( TRUE (),
    
        HASONEFILTER ( Dataset[Category] ),
        	SELECTEDVALUE (
        		Dataset[Cateogry],
        		"Select Category" 
        	),
        	
        HASONEFILTER ( Dataset[Location] ),
        	SELECTEDVALUE (
        		Dataset[Location],
        		"Select Location"
        	),
        	
        "No record available"
    )

 

If you want to save time, then you want to carry out calculation inside SWITCH, not outside. SWITCH will often (not always) perform only the needed calculations whereas if you take out the formulas and put them in variables outside SWITCH, all of them will get calculated (unnecessarily most of the time).

 

Best

D

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

[ToolTip Tile] =
    SWITCH ( TRUE (),
    
        HASONEFILTER ( Dataset[Category] ),
        	SELECTEDVALUE (
        		Dataset[Cateogry],
        		"Select Category" 
        	),
        	
        HASONEFILTER ( Dataset[Location] ),
        	SELECTEDVALUE (
        		Dataset[Location],
        		"Select Location"
        	),
        	
        "No record available"
    )

 

If you want to save time, then you want to carry out calculation inside SWITCH, not outside. SWITCH will often (not always) perform only the needed calculations whereas if you take out the formulas and put them in variables outside SWITCH, all of them will get calculated (unnecessarily most of the time).

 

Best

D

AntrikshSharma
Community Champion
Community Champion

You can remove that IF condition from HASONEFILTER because it already returns TRUE if the column has one filter else it returns FALSE. You can try this construct, let me know if it doesn't work for you.

ToolTip_Tile =
VAR SelectedMainCategory =
    HASONEFILTER ( Dataset[ Cateogry] )
VAR SelectedLocation =
    HASONEFILTER ( Dataset[Location] )
VAR MainCategory =
    SELECTEDVALUE ( Dataset[ Cateogry], "Select Category" )
VAR Location =
    SELECTEDVALUE ( Dataset[Location], "Select Location" )
RETURN
    SWITCH (
        TRUE (),
        SelectedMainCategory, MainCategory,
        SelectedLocation, Location,
        "No record available"
    )

 

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.

Top Solution Authors