Forum Discussion
Create a report from a table with many binary values
Hi, I want to create a barchart from an order table that has 30 products stored as binary values. Example. Product A = TRUE. I want to create a chart where I can see in one go the frequency of ...
Hi Anonymous ,
After unpivoting your table, you could use matrix visual to show your data. Put product names in the "Column" option and put order numbers in the "Row" option.
Have you considered unpivoting your Product columns?
Greg Hi thanks for the input. Considered yes, but I will try that. I was thinking my report table visual would then also look like an unpivoted table, something that I don't want.
Order 1 - Product A
Order 1 - Product D
...
Anonymous
Please consider unpivot.
https://radacad.com/pivot-and-unpivot-with-power-bi
You can use summarize, select column and union . but not suggested
Union( selectcolumns(table,"Order",table[Order],"Product","Product A", "Date",Table[Order date],"Value",table[Product A]), selectcolumns(table,"Order",table[Order],"Product","Product B", "Date",Table[Order date],"Value",table[Product B]), selectcolumns(table,"Order",table[Order],"Product","Product C", "Date",Table[Order date],"Value",table[Product C]), selectcolumns(table,"Order",table[Order],"Product","Product D", "Date",Table[Order date],"Value",table[Product D]) )Appreciate your Kudos.
