Navigation

[Mamta15]

for eg:

If i have a heading Market_NPS and inside that 7 or 8 brands are there like AMI, NZI, AA etc. I want to show market nps for each brand on monthly basis. How to do that

Main Categories are :-

Market_NPS - AMI (Brands)

                       NZI

                       AA

                       State

                       Tower

Market_Share - All Brands

Can anyone tell me how to do this navigation on power bi desktop 

[v-chuncz-msft]

@Mamta15,

Better to illustrate with a simple example. First take a look at GROUPBY Function.

[GilbertQ]

You could do this by going into the Query Editor and duplicating the column where you have got all the different brands.

Then you can split it by the "_" delimiter and then use this new column for your navigation?