Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Pie Chart counting data from different columns

Hello everyone,   I am quite new to Power BI,  will try to explain you my problem as best as I can:   I have a table like this:   Company name    Country              Service 1              Ser...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi Anonymous ,

Assume your table is like:

You can copy the table, and then "unpivot" the copied table. Then in Edit quieries, select all subject columns from "Service1" to "Service3", then in "Transform"->"Unpivot columns", the dataset would change as below:

Then the pie chart can count the number of services:

 

Best Regards,

Liang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you Liang for your response.
     
    I realize I have made the table too simplistic, but I actually have way more columns and about 2000 rows. I am also using functions such as count the number of elements in my dashboard, so as I was mentioning pivoting is not an option for me.
     
    Do you think there is any way to solve the problem, for example, using the new measure function directly in the report view? Or through a simple piece of coding?

    Thank you in advance for your help

     

    Matteo