SAC- Is there any way to highlight negative values ​​in the table with model with account dimension?

[honza111]

Hello all,

We have the difference Actual -Budget in the storie's table and we need to highlight negative values.
Our model is new model type with an account dimension.
Is there any way to highlight negative values ​​in the table with model with account dimension?

With thresholds, this is not a problem if a model without an account dimension is used.
But
"Thresholds are not supported yet for the new model type (Model with an account dimension)"

Thank you.

[VijayBhaskaran]

Hi @honza111l,

Actually the thresholds are supported in the new model type based on the Account dimension. Please find the proof below.

New model type with Account Dimension:

Threshold creation using the Conditional formatting option available in Story

Use the Show thresholds in the designer under measures to view the red color in the table

Output:

I hope this is what you are expecting.

Thanks and Regards,

Vijay Bhaskaran

[VijayBhaskaran]

If this what you are looking for, can you please make this as correct solution.

[honza111]

Hi Vijay, thank you for your reply. Unfortunately, in the table in our story, the Threshold option is not accessible see screenshots. ...Thresholds are not supported yet for the new model type (model with an account dimension)...

[honza111]

Hi Vijay,

thank you for your reply.
Unfortunately, in the table in our story, the Threshold option is not accessible see screenshots.
...Thresholds are not supported yet for the new model type (model with an account dimension)...

Story is classic story.

Model Information:
Model Type: Analytic

Model Layout: Measure

System information of us tenant:

Versions
2024.8.18 (Client)
2024.8.16 (Server)

Build Dates
Wed Jul 03 2024 17:08:37+0000 (Client)
Wed Jun 19 2024 18:50:28+0200 (Server)

Where can the problem be? Any idea?

Thanks and regards

Jan