Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |