order of values

[Sonne]

Hello, 

in my Power BI matrix Ihave as column "period" and as values 1) food and 2 ) drinks  .

I see alway   both values ( food and drinks) per period, but i want to see first all periods for food and then all periods for drinks 

it should look like this in Power BI :

is this possible ?

the table looks like this : 

[amitchandak]

@Sonne , Not very clear. If you take period on the row it should be like that?

[Sonne]

if I take period into rows I m getting this view :

this is not what I want. 

i want per person first food from P08-P12, than drinks from P08-P12

in excel in the pivot i can change the order of values : 

[V-lianl-msft]

Hi @Sonne ,

What does the original data table look like?Please show with screenshots or paste table data.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sonne]

hello , this is the excel table inserted into power BI. I can not change the format as this file is coming from a tool : 

[V-lianl-msft]

Hi @Sonne ,

Based on the data you provide, food and drinks are at the same level and cannot be drilled to meet your needs. You need to use bookmarks to solve this problem.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.