Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello people,
I wanted to ask for help with a thing I am stuck on. Using arrows, I need to show in the last column if the value has either increased or decreased. When tried conditional formatting, I was able to do the arrows pointing in upward direction showing increase in value but I am unable to show the downward arrow for decrease of value. I also tried DAX programming, but seems it didn't work either. Can someone here please guide me. Attaching my screenshot below for your reference.
Solved! Go to Solution.
Hi @Anonymous ,
Based on your description, I have created a simple sample:
Please try:
Measure2 = IF(SELECTEDVALUE('Table'[Prior Value])<SELECTEDVALUE('Table'[Current Value]),1,-1)
Then apply it to the visual -> conditional formatting:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
What does your raw data look like? You can use the if function or switch function for these two columns of data to return the comparison result as a value like 1, -1, and then do conditional formatting.
For example:
Measure2 = IF(SELECTEDVALUE('Table'[Prior Value])<SELECTEDVALUE('Table'[Current Value]),1,-1)
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Based on your description, I have created a simple sample:
Please try:
Measure2 = IF(SELECTEDVALUE('Table'[Prior Value])<SELECTEDVALUE('Table'[Current Value]),1,-1)
Then apply it to the visual -> conditional formatting:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi There,
Thanks for the solution, but not all rows are showing the right trends.
Below is the conditional formatting condition used by me:
I would appreciate it if you help me out with the right condition, been stuck here for past 3 days.
in order for your measure to work correctly you need clean data. Neither "NA" nor "BBB+" are numbers.
Hi, would you suggest null value in place of NA? also BBB is the Bond rating.
Use whatever data is appropriate in your scenario. Don't mix numbers and text values.
Is there a way to apply conditions based on columns?
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |