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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AndreasMEG
Frequent Visitor

Sort data over period and count - Multi Row Card

I wish to sort and count the data as below. 

I have Availability data from 01-01-2023 - 01-02-2024 and wish to know the average and sort it as shown in the left MultirowCard.

 

I also wish to know the average Availability for the period sorted by age. (Right - MultirowCard) 

 

 

AndreasMEG_0-1712309754343.png 

 

AndreasMEG_4-1712311328268.png

 

 

 

1 ACCEPTED SOLUTION

lbendlin_0-1712616086409.pnglbendlin_1-1712616100280.png

see attached.  Please check the Power Query part - there is some data preparation required.

 

 

View solution in original post

4 REPLIES 4
AndreasMEG
Frequent Visitor

AndreasMEG_0-1712554111926.png

 

lbendlin_0-1712616086409.pnglbendlin_1-1712616100280.png

see attached.  Please check the Power Query part - there is some data preparation required.

 

 

lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Table Data_

IDDateIBNAvailability
501601-01-202301-02-2014100%
501701-01-202301-04-201095%
501801-01-202301-09-200082%
501901-01-202301-07-1995100%
501601-02-202301-02-20145%
501701-02-202301-04-201033%
501801-02-202301-09-200095%
501901-02-202301-07-1995100%


Dax Interval

IntervalAverage
Availability
95-100%1
85-95%1
65-85%0
40-65%2
20-40%0
0-20%0


Dax age (Ex. 01/01-1985 - 31/12/1989)

AgeAverage
Availability
1985-1990 
1990-1995 
1995-2000100%
2000-200589%
2005-2010 
2010-201558%
2015-2020 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.