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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
okletsgo
Advocate II
Advocate II

Bar chart split by age ?

In my data there are a column with Age like below

Age
34
22
27
44
33
24
54
41
36
29
25
etc....etc..

What I want to do is a create a bar chart like 21-25 , 26-31, 36-40, 41-50

 

How can I do it as uncomplicated as possible?

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

Hi okletsgo,

 

Have you solved your issue by now? If you have, could you please mark one answer to finish the thread?

 

Regards,

Jimmy Tao

themistoklis
Community Champion
Community Champion

@okletsgo

 

Maybe this workstream will also help you

v-yuta-msft
Community Support
Community Support

Hi okletsgo,

 

So is there some logic in "21-25 , 26-31, 36-40, 41-50"? To be general, to achieve the pattern expression like "21-25 , 26-31, 36-40, 41-50", you may use CONCATENATEX(). If you have other requreiment, please post more details.

 

Regards,

Jimmy Tao

Read my article about banding in DAX here



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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