Scatter chart showing the latest revision for each facility

[Fern_21]

Hi all!

In Power BI, this scatter chart shows all the facilities with their revisions. For example, a facility might have revision 2 and 3, but I only want to show the latest one, which is revision 3. So, I need to display only the latest revision for each facility. How can I do that?

Thanks

[v-lgarikapat]

Hi @Fern_21 ,

Thanks for reaching out to the Microsoft fabric community forum.

@burakkaragoz , @Nasif_Azam 

Thanks for your prompt response

@Fern_21  

I’ve implemented the logic to display only the latest revision per facility in the scatter plot using a sample dataset in Power BI. I’ve also attached the PBIX file for your reference  feel free to review it.

If you're still encountering any issues or need further assistance, please don’t hesitate to reach out. We’ll be happy to help you further.

Best Regards,

Lakshmi Narayana.

[v-lgarikapat]

Hi @Fern_21 ,

I wanted to check if you had the opportunity to review the information provided , Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" so other members can easily find it.

Looking forward to your response.

Best Regards,

Lakshmi Narayana

[burakkaragoz]

Thanks @Nasif_Azam , for the clear and detailed explanation. Your solution covers both the calculated table and calculated column approaches very well.

I’d like to add that if your dataset updates frequently or you’re working with a large model, using the calculated table method is often more efficient for visuals like scatter charts, as it keeps the data model clean and optimized for performance.

If you need to retain all revisions for other visuals but only want the latest revision in this specific scatter chart, you can use the filtered table only in that chart and keep your main table unchanged for other analysis.

Let us know if you run into any issues while applying these steps or if you need help with a specific DAX formula for your table structure.

Great question and great answer!

[Nasif_Azam]

Hey @Fern_21 ,

To display only the latest revision per facility in a Power BI scatter chart like the one in your screenshot, you need to filter your dataset so that for each facility, only the row with the latest revision is included.

Show Only the Latest Revision per Facility

1. Identify Key Columns

You need:

• Facility (or similar unique identifier)

• Revision (should be a numeric or datetime indicating version)

• Data columns like Total Volume and Total Gross Dry Weight

2. Create a Calculated Table (Recommended for a separate filtered dataset)

In Power BI, go to Modeling > New Table, and enter:

LatestRevisions =
VAR LatestRevisionPerFacility =
    ADDCOLUMNS(
        SUMMARIZE('YourTable', 'YourTable'[Facility]),
        "MaxRevision", CALCULATE(MAX('YourTable'[Revision]))
    )
RETURN
    SELECTCOLUMNS(
        NATURALINNERJOIN('YourTable', LatestRevisionPerFacility),
        "Facility", 'YourTable'[Facility],
        "Revision", 'YourTable'[Revision],
        "TotalVolume", 'YourTable'[Total Volume],
        "TotalWeight", 'YourTable'[Total Gross Dry Weight]
        -- Add more columns as needed
    )

3. Use the New Table in the Scatter Chart

In your scatter chart:

• Axis: Use Total Volume (from LatestRevisions)

• Values: Use Total Gross Dry Weight (from LatestRevisions)

• Details or Legend: Use Facility

Alternative: Use a Calculated Column (If Table Must Stay the Same)

Add a column to tag the latest revision:

IsLatestRevision = 
VAR CurrentFacility = 'YourTable'[Facility]
VAR CurrentRevision = 'YourTable'[Revision]
VAR MaxRevision =
    CALCULATE(
        MAX('YourTable'[Revision]),
        ALLEXCEPT('YourTable', 'YourTable'[Facility])
    )
RETURN IF(CurrentRevision = MaxRevision, 1, 0)

Your scatter chart will now include only the most recent revision per facility, giving you a clean, meaningful comparison like the one shown.

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam