Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have been looking at different visuals for complex line charts and settled on the relatively new PlotlyJS visual from Appsource. It provides the flexibility I am looking for to show multiple likes and splits and aggregations where the basic Power BI charts cannot hand multiple lines with Legend in the same chart.
The interface allows the trace to be defined as follows.
where time is on the x-axis and Power is on the Y axis. In the table, the power is representative of multiple entities that are indicated in the unitinSystem value so there is a Transform associated with the line (trace 0) as
In terms of data presentation, the data is there and looks as follows:
Now, when I do the same for a chart wherein there are multiple lines, for example.
... and with a Transform and Filter applied to the data...
The resulting graph shows the line as:
The primary problem is that I want to replace "trace 0" with HPolDL_AGCCap and "trace 1" with HPolDLOscGain which are more meaningful to the audience without having to look at the graph construction.
Any help is appreciated.
Hello,
Unfortunately the feature doesn't work properly with X axis. I will include the fix to the next version of the visual.
Thanks for question/idea.