Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
80 | |
78 | |
70 | |
70 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |