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.
Hi,
In below requirement,
If select India>5M then India column value should highlight red
If select USA>1M then USA column value should highlight red
Is this possible to select conditional filter in dropdown and display conditional formatting based on that?
Solved! Go to Solution.
@v-lili6-msftI have solved this problem.
1) I have created dimsion table Country, with India>5M and USA>1M as values
2) I have created two measures
measure1=VAR HAPP1 = VALUES(Table1[India]) RETURN IF ( ABS(HAPP1 ) > 5000000 ,1)
measure2=VAR HAPP2 = VALUES(Table1[Americ]) RETURN IF ( ABS(HAPP2 ) > 1000000 ,2)
3) Then i have created third measures which will call above two measures
measures3=
4) Go to conditional formatting,select measure3 in rules and select value 1 and 2 for red .
hi, @atul9063
After my test, you could this way as below:
Step1:
Create a highlight table map to region field (USA, India, etc.) of basic table
For example
Note: Do not create a relationship between them
Step2:
Create a measure like this
Measure = IF(SELECTEDVALUE('Table 2'[Type])=SELECTEDVALUE('Table'[Type]),1)
Step3:
Set Conditional formatting like below:
Result:
Best Regards,
Lin
@v-lili6-msftI have solved this problem.
1) I have created dimsion table Country, with India>5M and USA>1M as values
2) I have created two measures
measure1=VAR HAPP1 = VALUES(Table1[India]) RETURN IF ( ABS(HAPP1 ) > 5000000 ,1)
measure2=VAR HAPP2 = VALUES(Table1[Americ]) RETURN IF ( ABS(HAPP2 ) > 1000000 ,2)
3) Then i have created third measures which will call above two measures
measures3=
4) Go to conditional formatting,select measure3 in rules and select value 1 and 2 for red .
hi, @atul9063
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |