Sorting rows in a matrix

[MelStaunton]

Hi there,

I have a matrix visual with rows"Budgeted Ebit" and columns "EAC Ebit" over weeks. As you can see in sample data the Bdgt Ebit only changes every so often, not every week, so ideally I would like to have the rows show only one row per value and plot the EAC Ebit in the same line until Bdgt Ebit changes. 

Yet, the values are automatically sorted from small to large.

I can't sort the column beforehand by date column as I have multiple identical values, so throws error.

If I add the date to rows, I get a row for each date, so lots of repeats and each week value for EAC Ebit in a separate row. Makes for a lot of scrolling.

I tried to group by Bdgt Ebit value, assigning first date it occurs, but then EAC Ebit values don't all have a matching date row, therefore plot in empty row.

Can somebody point me in the right direction please?

Thanks!!

with dataautomatically sorted ascendingSample data

[MelStaunton]

For clarification a screenshot with the row value EBIT showing, not just the date.

[amitchandak · Accepted solution]

@MelStaunton , you want one column not to repeat and others to repeat. That is not possible in Matrix now.

 I logged and idea for that, vote for it

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table