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,
My Power BI is connected to a database containing information on movies as per below.
My request is simple: how can I display in a single pie chart the proportion of movies by genre, cumulating the Genre1 and Genre2 ?
Thank you for your help,
Alexandre.
Solved! Go to Solution.
Hi @AlCado
You may use 'Unpivot other column' in Query Editor first. Then you may get the pie chart as below.
Regards,
Cherie
Hi @AlCado
You may use 'Unpivot other column' in Query Editor first. Then you may get the pie chart as below.
Regards,
Cherie
Thank you both very much it's exactly what I needed !
You need to create a new column
CumulativeGenre = CONCATENATE ( Movies[Genre1] & ", ", Movies[Genre2] )
Now use the Pie Chart as usual.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |