Forum Discussion
graphic representation
Good morning,
I want to display this visual on power bi with the reference right.
Do you have any idea.
THANK YOU
Poojara_D12 I can do the representation, it's just the line and the colors on the graph, below the line it's green and above it's red
Poojara_D12
Super User
Super UserAnonymous
- Add Y to the Y-axis and X to the X-axis in a Line and Area Chart.
- Create two DAX measures:
- Green Area: IF(Y <= Threshold, Y, BLANK()).
- Red Area: IF(Y > Threshold, Y, BLANK()).
- Add these measures to the chart and format:
- Set Green Area to green and Red Area to red under Data Colors.
- Done! The chart now has green below and red above the line.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS