Forum Discussion
Community Championcomments 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?
2 Replies
medeResolver I
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
mede great thank you! what if you wanted to add other commentary manually? any ideas around that
