topic Adding graphics to columns created by using "quick measure" in DAX Commands and Tips

Adding graphics to columns created by using "quick measure"

PC2022 — Tue, 05 Dec 2023 16:14:13 GMT

I created new measures to calculate weighted avg for Jun-Nov.

Now i would like to add graphics for each column comparing each month to a previous month to display whether the price went up/down/didn't change, like in the example below:

Is it possible to do?

Re: Adding graphics to columns created by using "quick measure"

Greg_Deckler — Tue, 05 Dec 2023 16:53:23 GMT

PC2022 Generally that is done with unicode characters, UNICHAR, or icon sets. Not quite sure what you are asking. Many times you create a measure to return the right UNICHAR character and set conditional formatting to field value. for example.

Re: Adding graphics to columns created by using "quick measure"

PC2022 — Tue, 05 Dec 2023 18:25:41 GMT

Unichar? can you please help with the formula? do i create new column for each month?

Re: Adding graphics to columns created by using "quick measure"

PC2022 — Mon, 11 Dec 2023 12:44:17 GMT

i would like to add icons for each column comparing each month to a previous month to display whether the price went up/down/didn't change. For example, July weighted avg went down compared to June, so i would like to add "down arrow" to July. It was recommended to create a measure to return the right Unichar character but i am not sure how.

Re: Adding graphics to columns created by using "quick measure"

Anonymous — Thu, 28 Dec 2023 07:23:15 GMT

Hi PC2022 ,

Actually there is indeed a way to create Custom Data Labels in Power BI. But to achieve this function, we’ll use Tabular Editor because it exposes the ability to write custom DAX to format our calculations.
You can refer to this document to achieve this:
Custom Data Labels in Power BI - Goodly

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