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,
This is the sample data.
I want to visual it into bar chat. My initial plan (this is what I think is possible) is to create new column for header with value in a single row. The 1 is just an indication of that single row is having that type of fruit so no aggregation on the 1.
Here my expected output
What operations should I do to get the extra column?
Hi @alvin199 ,
Here are the steps you can follow:
1. Enter the power query, select [apple],[orange],[grape],[lemon],[startftuit],[pearl], right-click—Replace Values.
Replace blank values with 0.
2. Select [apple],[orange],[grape],[lemon],[startftuit],[pearl] and click Unpivot Columns.
Result:
3. Create calculated column.
CON =
IF(
'Table2'[Value]=1,
CONCATENATEX(FILTER(ALL(Table2),[Name]=EARLIER([Name])&&'Table2'[Value]=1),[Attribute],","),[Attribute] )
Flag =
var _1=COUNTx(FILTER(ALL(Table2),'Table2'[Name]=EARLIER('Table2'[Name])&&'Table2'[Value]=1),[Value])
var _if1=IF(
[Value]=1,_1,0)
return
IF(
AND(_if1=1,[Value]=1) || _if1=0,_if1,_if1-1)
4. Create measure.
Measure =
MAX('Table2'[Flag])
5. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hello @alvin199
If you could send a sample .pbix that demonstrates what you are looking to get, it would really help provide you with a quick solution.
You can send the sample .pbix file by adding it to your drive or dropbox and add the link here.
Regards
Kumail Raza
Here is the sample of the data.
The column needs to combine header name in new column is from column D to J.
Hello @alvin199
If I have understood your requirement clearly, then this visual willl answer your query.
Regards
Kumail Raza
Did this help? Kudos are appreciated!
Consider Accept it as the solution to help the other members find it more quickly
Hi @Kumail
Thank you for your reply.
Can you share the PBIX file for me to know how it works?
Thanks.
Hello @alvin199
https://drive.google.com/file/d/1Ypu3Av8v71i9ilBZvG5kgfppSYje-BT0/view?usp=sharing
Regards
Kumail Raza
Did this help? Kudos are appreciated!
Consider Accept it as the solution to help the other members find it more quickly
Hi @Kumail
The y-axis should be the count of Joiners while the x-axis is the Attribute (Coding, Art and etc.).
The difficult part is to handle each joiner will have 1 or more than 1 attribute.
Yup, I have look into your suggested work but it is not what I am expected.
The y-axis should be the count of Joiners while the x-axis is the Attribute (Coding, Art and etc.).
The difficult part is to handle each joiner will have 1 or more than 1 attribute.
@alvin199 , With this model better to create additional columns
Yes create additional columns as for having more than 1 column in a single row.
However, how to identify the 1 and then combine the column header for those having more than 1 "1" in individual column?
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |