05-07-2018 02:18 AM
Fantastic report! I have a question if I may. How do you get to display the selective labels in the cumulative chart? Do you create separate measures for each (MAX or whatever) and add them as values?
Thanks for your help,
glad you like the report.
you can control density of labels in a line chart by adjusting the 'Label density' (Format - Data Labels - Label density)
no need to create separate measures unless you need to highlight specific dates.
hope it helps,
Is the Line graph the Power KPI custom visual by any chance? The default Line Chart Visual in Power BI Desktop (April 2018 version) is lacking the "label density" option.
yes, the 'label density' is a feature of the standard Line Chart.
if you don't see it, try this: adjust your Axis to 'DateID' (day) instead of 'Date Hierarchy'.
Thanks for that. Therein lies my "problem": I'm using a non-standard date table (Month granularity) so I assume that's why the option isn't available. The funny thing is the Power KPI visual does have it as an option for this particular graph, so I may just change it to that visual.
Thanks again for your help!
Thanks for sharing this excellent example!
How did you create the KPI? Which visual(s) are you using to compose the KPI (Title, Value, Indicator Symbol)?
Thanks for any insight you can share.
I used the standard Card visual for both KPI and Arrow, and a Chicklet Slicer for the Unit/Profit Selection.
To get the arrow-up (green) / arrow down (red) symbols I used UNICHAR and colored Data Labels green (128315 is by default red).
here are the measures:
hope it helps