Forum Discussion
Solved
How to show max value all the time
Hi! I have data consist of app name, category, date, index A, index B, and index C. Refer to picture below, I want to show the index in scatter plot visualisation. For example i choose In...
Hi Farrah24,
You can add a variable with summarize function to summary the app name and correspond max index value, then you can use iterator function sumx to aggregate the max values of different app groups.
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
thankyou for the reply!
I've tried the code and it still didn't work. the maximum value still changes over ti I attached link to access the pbix and dataset to make it easier
App Index PowerBI & Dataset
Thanks in advance!
Hi Farrah24,
You can add a variable with summarize function to summary the app name and correspond max index value, then you can use iterator function sumx to aggregate the max values of different app groups.
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng