How to use conditional alt text?

[Josh_Lalonde]

Hello, I'm looking for some instructions/advice on how to generate conditional alt text. The dialog box for conditional alt text is not very intuitive, and the Learn more link at the bottom goes to a page about conditional formatting in general that doesn't contain anything specifically on conditional alt text.

The Format by combo box only displays one option (Field value), and the Based on field combo box doesn't allow you to select most fields. Once you select a field in the Based on field combo box, another combo box called Summarization is displayed, but it only contains two options, First and Last.

Any help on how to use this function would be much appreciated.

[Anonymous]

Hi @Josh_Lalonde ,

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.Hope to hear from you‌‌

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Josh_Lalonde ,

Maybe I didn't understand your question clearly before.

But actually, steps for Conditional Formatting(formatted by Field value) is always the same, no matter for column values or alt text... 

You could click the "fx" button to open the conditional formatting dialog. And just as the screenshot shown, when you click "Learn more" button in the lower left corner, it will also lead you to the official document about Conditional Formatting.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Josh_Lalonde]

Hello @Anonymous, thank you for your reply, but my question was specifically about conditional alt text, not conditional formatting in general. The link you shared doesn't contain any information specifically on conditioinal alt text.

Is there any information available on conditional alt text?

[Anonymous]

Hi @Josh_Lalonde ,

With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values. You can also represent cell values with data bars or KPI icons, or as active web links. You can apply conditional formatting to any text or data field, as long as you base the formatting on a field that has numeric, color name or hex code, or web URL values.

In addition, Conditional formatting needs an aggregation or measure to be applied to the value. So you may create a measure like this and then apply it to "Based on Field".

Alt Measure = SWITCH(MAX('Table'[Country]),"China","a","America","b","France","c","Japan","d","Korea","e")

Refer to:

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.