Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
NavaneethArra
Regular Visitor

how to get max of particular category based on category not by value

 

Runtype
BOP
Assumption 1
Assumption 2
Assumption 3
Roll forward EOP
Population update EOP

 

output to be as below based on dynamic selection

Runtype
BOP
Assumption 3
Roll forward EOP
Population update EOP

 

 

I have 4 Quarters slicers selection, based on the slicer selection the assumptions gets added or removed ... i wanted to show the latest assimption along with the remaining BOP,roll forward EOP and Population 

 

2 REPLIES 2
NavaneethArra
Regular Visitor

Hi 

Basically we get the quarterly data for these Run types , however all the Runtypes would be same but the assumptions gets added ,,,, and we need to show the latest assumption everytime whenever we select the slicer based on quarter 

For ex : 

We have Q3 2023 

where in we have 

BOP 
Assumption 1
Assumption 2
Population EOP 
Roll forward EOP

In this case i when i select Q3 2023 i should show the MAX of assumption which is Assumption 2 along with 
remaning run typres 

Like 

BOP
Assumptions2
Roll forward EOP 
Population update EOP

 

Runtype
BOP
Assumption 1
Assumption 2
Assumption 3
Roll forward EOP
Population update EOP
lbendlin
Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.