Trend analysis

[Anonymous]

Hi all, I've got a client asking for a feature I'm not sure even exists in PBI. Short version: We collect answers i.e Good, Bad, Very Good, from questions. The client would like to see Trends to know if they're improving or getting worse. The main problem is that the more questions getting answered, the more results we get in. How's that a problem you say? Well if, for example, we get in 100 answers one month and 40 of them are "bad" then the nexts month we get in 1000 answers and 400 of them are "bad" that's a huge spike for the answer: Bad. That's not a "trend" per se. I'd like to get a factor instead and use that as a line chart to get a better representation of the trend.

I've noticed there's a visual for this: 100% Stacked Bar Chart. This one creates a factor by it's self but the visual isn't what I'd like to use.

Question: Anyone got any tips on how to create this factor?

[amitchandak]

@Anonymous , You can use line visual with the legend

Sankey visual - https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=sankey&page=1