Forum Discussion

dk_24's avatar
dk_24
Helper I
8 years ago
Solved

For Dynamic Axis and Measures

Hello Team, i am new to power BI , i want to create a bar charts with dynamic axis for present quarter and last six months i have 4 years data.for every quarter and six months axis and date should c...
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    dk_24

     

    You can put different level on Axis simultaneously. In this scenario, you should create a Calendar hierarchy. Then you can drill down to corresponding level you expect.

     

     

     

    Regards,

dk_24's avatar
dk_24
Helper I
8 years ago

Hello Team,

i am new to power BI , i want to create a bar charts with dynamic axis for present quarter and last six months i have 4 years data.for every quarter and six months axis and date should change.

required output :

 

sample fields : Order ID( ForCount), Order Date.

 

Thanks,

 

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

dk_24

 

You can put different level on Axis simultaneously. In this scenario, you should create a Calendar hierarchy. Then you can drill down to corresponding level you expect.

 

 

 

Regards,