cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
perplexedDev Frequent Visitor
Frequent Visitor

Nested values in xaxis

Suppose the data is of the format

TestDate  TestName  Result

04/19         A                10.6

04/19         B                 12.8

04/19         C                12

04/20         D                10

 

I want to create a chart where the x-axis values will be nested or grouped. Ie, its should have dates and Test names grouped in dates. Y axis should be Result. Below example shows a sample for 04/19 data.

 

sample.png

 

5 REPLIES 5
Sean Super Contributor
Super Contributor

Re: Nested values in xaxis

This feature is not available yet.

 

if you'd like to see it - Vote here

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11524623-nested-x-axis-labels

Sean Super Contributor
Super Contributor

Re: Nested values in xaxis

@perplexedDev

Ok clarification. You actually don't need Nested X-Axis - just do as in image below

Nested.png

This is what Nested X-Axis and the Idea I posted in previous reply was really about...

Real Nested X Axis.png

bdenison99 Frequent Visitor
Frequent Visitor

Re: Nested values in xaxis

That didn't help any... I still get only one line, and one value on the X-Axis.  It looks like I'll have to stay with Excel spreadsheets since Power BI doesn't even come close to matching the functionality there at this time.

robinwilson16 Frequent Visitor
Frequent Visitor

Re: Nested values in xaxis

Yes I agree this is a vital function that has been missed and I whichever way I try to do this I cannot get more than one group to appear on the X axis making Power BI rather limited.

robinwilson16 Frequent Visitor
Frequent Visitor

Re: Nested values in xaxis

I cannot find a way to get more than one group to appear on the X axis either and this is a vital missing feature making Power BI much less useful as a result.

 

I tried to vote on the user voice site but it appears to be broken at the moment:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11524623-nested-x-axis-labels

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)