Highlight a menu if condition

[FaCe]

Hi all,

i'm looking for a way to "highlight" a menu item when are records in a specific view (slice).

i.e. if are records with due date today i'd like to "highlight" the menu "SCADENZA OGGI" 

Where highlight could be showing it in yellow, underlined, bold or other stuff.

Is it possible in someway ?

[Suvrutt_Gurjar · Accepted solution]

I believe  one cannot highlight or mark yellow etc. as one can do with format rules for other column text. However you could use a display name expression something like below for the view that will show record count under certain conditions such as order date for today etc. However best to first create slice for the desired condition and then use the slice based count expression in the view's display name because SELECT() expressions can be expensive.

The view display name property is something like below

CONCATENATE("All Orders(", COUNT(Todays_Orders[Order ID]),")")

Here "Todays_Orders" is the slice on the Orders table that lists Orders with today's  [Order Date]

[FaCe]

Great, thank you, it works.

CONCATENATE("SCADUTE (", COUNT(SCADUTE[SCADENZA]),")")

(why appears This formula is not evaluated in the context of a row, so column values are not available ?)

Unfortunately actually in Desktop version there's no way to display the menu completely with icon + text (hoping in a near future it will be enabled as option) so there's no way to know how many SCADUTE tasks there're until expand menu.

If i would like to remove the (0) there's a way with a condition ifs ?

And i could hide completely menu if there're no records available ...