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,
a basic quick question,
if I have a column A , and column A returns either 'b' and 'c', but I want to show them both on a pie chart,
how do I go about it?
I have applied
bA = (tablename[A] ), 'b'
cA = (tablename[A] ), 'c'
where am I wrong?
Solved! Go to Solution.
Proud to be a PBI Community Champion
Thanks,
for some reasons I still get syntax error on the logic but I belive this is what I need,
Hi atrinhatra,
A pie chart at least needs two columns, value column and legend column, if columnA is a category column, put columnA to legend field and another column to value field.
Regards,
Jimmy Tao
You may have missundrestood my question.
columnA returns 'yes' or 'no'
but I want to show if columnA = 'yes' show 'pass'
if columnA = 'no' show 'failed'
another word , I am asking the DAX syntax of above
@Anonymous Is this what you are looking for ? Try this as a new column
Flag = SWITCH(TRUE(),Table[ColumnA]="Yes","Pass",Table[ColumnA]="No","Failed")
Proud to be a PBI Community Champion
Thanks, Yes thats what I am after, however what does FLag represents? the code gives an error " THE syntax for 'FLag' in incorrect, (DAX(..........
Proud to be a PBI Community Champion
Thanks,
for some reasons I still get syntax error on the logic but I belive this is what I need,
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |