Nested values in xaxis

Question

Suppose the data is of the formatTestDate&nbsp; TestName&nbsp; Result04/19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.604/19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.804/19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1204/20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;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.&nbsp;&nbsp;

sean · Answer

This feature is not available yet.&nbsp;if you'd like to see it - Vote herehttps://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11524623-nested-x-axis-labels

sean · Answer

perplexedDevOk clarification. You actually don't need Nested&nbsp;X-Axis - just do as in image belowThis is what Nested X-Axis and the Idea I posted in previous reply was really about...

bdenison99 · Answer

That didn't help any... I still get only one line, and one value on the X-Axis. &nbsp;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 · Answer

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&nbsp;X axis making Power BI rather limited.

robinwilson16 · Answer

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.&nbsp;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

Forum Discussion

Nested values in xaxis

5 Replies

Related content

Nested IF

Parsing list values in a nested table

Nested IF

RLS with nested AAD groups

background color of linechart dependent on xaxis values