The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Problem Statement: I have a table with multiple feature Columns. I have to show the aggregated value of those feature column on a line or bar chart. I need one slicer where all these Feature columns get listed and if I select any of the Feature it should show only that value. Basically, it should filter on my slicer.
I created another table with unpivoted columns from the original table and Renamed attribute as Features. Now, I have the list but both the tables are not connected to each other and hence unable to filter. Need help to resolve this issue. I cannot unpivot and use the attribute column in the same original table as it will expand the row count into millions.
Solved! Go to Solution.
Hi @v-pussah
If you want aggregated results, you can aggregate them in Power Query directly by using Group By feature.
After unpivoting, group by Attribute column and get aggregated values in a new column. For example in above image, I calculate Sum for each group member.
Then use this new structured table to create a bar chart.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @v-pussah
If you want aggregated results, you can aggregate them in Power Query directly by using Group By feature.
After unpivoting, group by Attribute column and get aggregated values in a new column. For example in above image, I calculate Sum for each group member.
Then use this new structured table to create a bar chart.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@v-pussah , when you unpivoted the table to have feature as row, then you can take slicer from that column or you can join the two table.
Or create a table
measure =
var _tab = allselected(Feature[feature])
return
calculate(sum(Table[value]), filter(Table, Table[Feature] in _tab))
Hi @amitchandak : This will not work. I cannot unpivot in the original table. So created a separate table. Now, how do i join these 2 tables.