Forum Discussion

Community Champion

8 years ago

comments in power BI

For month end reporting scenarios where people add commentary to reports / dashboards. Just wondering how people are approaching this in Power BI?

Resolver I

8 years ago

Hi,

Recently i have been using custom visual called "Enlighten Data Story" for periodic comments or executive summaries.

It's a little bit laborious to set up individual measures and filters but it works wonders.

For example:

- Sales are # by # and trend is #. (All # is a measure.=

It ends up showing like this: - Sales are up by 5% and trend is upwards.

first and third # are derived based on IF THEN based on measures.

I also use CONCATENATEX to list selected filters, i.e.

Selected Categories = CALCULATE(CONCATENATEX(DISTINCT(Categories[Category_A]), Categories[Category_A], ","))

vanessafvg
Community Champion
8 years ago
mede great thank you! what if you wanted to add other commentary manually? any ideas around that