Forum Discussion
plot graphics Power BI
Hi apostol-raf ,
We need unpivot the topic columns first in power query editor:
then we can create a measure to show the value
Measure = DIVIDE(SUM('Table'[Value]),CALCULATE(SUM('Table'[Value]),ALL('Table'[Attribute])))
If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared？
By the way, PBIX file as attached.
Best regards,
| messageID | Topic1 | topic2 | topic3 | topic4 | Autor |
| ID1 | 0 | 1 | 1 | 0 | client |
| ID2 | 1 | 0 | 0 | 0 | client |
| ID3 | 1 | 0 | 1 | 1 | salesMan |
where 1 or 0 apply if the message contein the topic.
I want get the next chart:
where on Y-axis i wont get percent of all summ, where on Y-axis i wont to get percent of all summ values in topics on each autor.
But in PB i get this **bleep**:
where my column group by autor, but i want group tematics and subgroup by autor
Hi apostol-raf ,
We need unpivot the topic columns first in power query editor:
then we can create a measure to show the value
Measure = DIVIDE(SUM('Table'[Value]),CALCULATE(SUM('Table'[Value]),ALL('Table'[Attribute])))
If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared？
By the way, PBIX file as attached.
Best regards,