The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
HI TEAM
SOURCE DATA
Universitycode | CollegeName | Category | subCategory | EduCategory | revenue | cost | Date |
A1 | Cape Town | HigherEducation | HigherEducation | HigherEducation | 120 | 45 | 19/7/2021 |
A2 | Cape Town | Masters | Masters | Masters | 121 | 23 | 19/7/2021 |
A3 | Pretoria | HigherEducation | HigherEducation | HigherEducation | 122 | 66 | 19/7/2021 |
A4 | Pretoria | Masters | Masters | Masters | 123 | 53 | 19/7/2021 |
A5 | Witwatersrand | Higher | Higher | Higher | 124 | 67 | 19/7/2021 |
A6 | Witwatersrand | Masters | Masters | Masters | 125 | 34 | 19/7/2021 |
A7 | Rhodes | HigherEducation | HigherEducation | HigherEducation | 126 | 56 | 19/7/2021 |
A8 | Rhodes | Masters | Masters | Masters | 127 | 86 | 19/7/2021 |
A9 | Mansoura | HigherEducation | Bachlers | Bachlers | 128 | 79 | 19/7/2021 |
A10 | Mansoura | HigherEducation | PHD | PHD | 129 | 69 | 19/7/2021 |
A1 | Cape Town | Masters | Masters | Masters | 120 | 66 | 19/7/2021 |
A2 | Cape Town | HigherEducation | HigherEducation | HigherEducation | 123 | 53 | 19/7/2021 |
A3 | Pretoria | HigherEducation | Ecommerce | Ecommerce | 124 | 67 | 19/7/2021 |
A4 | Pretoria | HigherEducation | HigherEducation | HigherEducation | 125 | 34 | 19/7/2021 |
A5 | Witwatersrand | Masters | Masters | Masters | 126 | 56 | 19/7/2021 |
A6 | Witwatersrand | HigherEducation | HigherEducation | HigherEducation | 127 | 86 | 19/7/2021 |
A7 | Rhodes | Masters | Medical | Medical | 128 | 79 | 19/7/2021 |
A8 | Rhodes | HigherEducation | HigherEducation | HigherEducation | 129 | 23 | 19/7/2021 |
A9 | Mansoura | Masters | Masters | Masters | 128 | 66 | 19/7/2021 |
A10 | Mansoura | HigherEducation | Hotelmangment | Hotelmangment | 129 | 53 | 19/7/2021 |
OUTPUT
SCATTER PLOT:- LEGEND- EduCategory
X Axis- cost
y axis - revenue
date slicer
university code slicer
once use selects any university code it shold change the scatter plot based on the legend
but user need green and red colour for the legends and it should be fix it means that if category value = educategory value then colour should be green else sub category value = educategory value then colour shouold be red
i am not able to set colour of legend power bi takes different after any other univerversity id selection
Thanks
@Anshenterprices , as of now we can not use conditional formatting once legend is used.
keep that on-axis and try conditional formatting, if they are more than one, use expand icon to expand
create a color measure and use that in conditional formatting using field value option
if( [category value] = "educategory", "green", "red")
refer if needed
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
139 | |
110 | |
107 | |
76 | |
62 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |