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 All,
I am trying to create a column in report which is based on previously built dataset but it doesnt give me create a new column.
The scenario is below
I wanted create a conditional column like
if Vendor Primary = Vendor Account No then 1 else 0 and then base don that i will highlight the row with some background color.
Create column option is not available when I right click on table
Ideas appreciated....
Is it possible that you're on direct query mode? You can't create new columns in a table on direct query.
But if you still want to do conditional formatting, you don't need to create a calculated column, just create a measure and format based on that.
Yes i am on DQ mode, also how would we create measure comparing two column values?
Hi @srlabhe
You can refer to the following measure
Measure =
IF (
SELECTEDVALUE ( 'Table'[Vendor Primary] )
= SELECTEDVALUE ( 'Table'[Vendor Account] ),
1,
0
)
Then put the field to the conditional formatting
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-xinruzhu-msft i tried the same andmoment i add the measure in report it shows me many records as below
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 |
---|---|
108 | |
106 | |
86 | |
77 | |
69 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |