dynamic report in columns

[Anonymous]

Have 2 check box filtters (this checkbox created left side and right is one table)

checkboxfilter1

AMERICA
INDIA

SOUTHAFRICA

checkboxfilter2

country

state

sales

balce

now when select checkbox 'sales' this field add in table  like wise mean checkbox should be columns

and check box ahould be rows

example

output like

from check i am select checkboX(Country ,state and sales now) and checkbox1 i am selected india

o/p: Country  state    sales

       india       Delhi     10K

      india   maharastra 20k

    india     chennai     30k

now i am select from checkbox2 is balance

o/p: Country  state    sales   balace

       india       Delhi     10K  2

      india   maharastra 20k  5

    india     chennai     30k  7

like that i need dynamic reports.

thanks

shanvitha

[PattemManohar]

@Anonymous  Please have a look into the similar thread that will be helpful

https://community.powerbi.com/t5/Desktop/filtering-fields-to-show/m-p/566781#M267437