Creating Scatterplot without Altering Table/Editing Query

[karissashapard]

Hi all,

I am building a report where I cannot alter the table as it is a live SSAS connection. I want to create a scatterplot where I extract values from 'Expense Type' which is things like car rental, dues and other general categories with their respective amounts and plot them against each other. Is there any way to extract this information and integrate it into the report without using 'edit queries'? Thanks in advance for your help!

[v-chuncz-msft]

@karissashapard,

You may try using DAX to add measures.