Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have a single data point which I have visualized in card visualization as in picture. Besides the value, I want to have a red or green triangle icon based on a condition. I can create a measure which returns trinagles but cannot relate that to this card. Can I get help on that?
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous ,
We can use UNICHAR to work on it. Here I have created a measure as below.
Measure 4 = IF(SUM('Table'[value])>10,UNICHAR(9650),UNICHAR(128315))
By default, the arrow is black rather than green as we required. There is no green up arrow in Unicode so we’ll need to change the font color of the arrow in Power BI to green.
For more details, please check the pbix as attached.
Hi @Anonymous ,
We can use UNICHAR to work on it. Here I have created a measure as below.
Measure 4 = IF(SUM('Table'[value])>10,UNICHAR(9650),UNICHAR(128315))
By default, the arrow is black rather than green as we required. There is no green up arrow in Unicode so we’ll need to change the font color of the arrow in Power BI to green.
For more details, please check the pbix as attached.
In the measure for the arrows you have to create and if statement checking the card visual's value. Then decide if it has to be green or red.
To help writing that statement we need more information about what is inside the card visual, what is the current measure and how does the data structure look.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |