Line chart and pie chart for last value on Power BI service report for streaming dataset

[m2020]

timestamp	value
6/22/2022 9:00	20
6/22/2022 11:00	40
6/22/2022 13:00	55.5
6/22/2022 15:00	75
6/22/2022 17:00	23
6/22/2022 19:00	35.4

Value can only be between 0 and 100.

I created a line chart for the past 30 days but the ask is to ask to add a pie chart as well for the last value received, so if it is 100 the pie chart will be full, 50 half, and so on.

Is this possible for a Power BI service report?

[m2020]

Thank you v-cazheng-msft for the response.

So the only way is to use PB Desktop?
I was trying to avoid it (keep it as simple as possible) as for the line chart I did not use it, and I had thought it was doable for the pie chart as well and I looked and I could not find a way to do it only in the PB service report and of course my first thought was I did not know where to look :).

[v-cazheng-msft · Accepted solution]

Hi @m2020,

For you have to make some calculations on the fields, you need do it in Power BI Desktop. In Power BI service, you couldn’t make changes to the model and you could only take the model to do some reports or share etc.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Hi @m2020,

You can try this solution but it may has some defects on legends, data labels.

1 Create a Calculated column to classify the timestamps in your table

Classify =
IF (
    'Table'[timestamp] = MAX ( 'Table'[timestamp] ),
    "" & MAX ( 'Table'[timestamp] ),
    ""
)

2 Create a Calculated table

NewTable = DISTINCT('Table'[Classify])

3 Create a Measure

LastValue =
VAR maxTime =
    CALCULATE ( MAX ( 'Table'[timestamp] ), ALL ( 'Table' ) )
VAR LatestValue =
    CALCULATE (
        MAX ( 'Table'[value] ),
        FILTER ( 'Table', 'Table'[timestamp] = maxTime )
    )
RETURN
    IF (
        SELECTEDVALUE ( 'NewTable'[Classify] )
            = ( MAX ( 'Table'[timestamp] ) & "" ),
        LatestValue,
        100 - LatestValue
    )

4 Create a Pie chart and set its Format as follows

Also, attached the pbix file as reference.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun