For Dynamic Axis and Measures

[dk_24]

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.

https://drive.google.com/file/d/0B5BkbOE1GSWHUXBLVm1NX0FzZzg/view?usp=sharing 

Thanks,

[Anonymous]

Hi

I have uploaded the file in googledrive at the link

https://drive.google.com/file/d/0B-CruXqyozMQS1ZSS3NXM1dSVzg/view?usp=sharing

Read the text box.

If this answers your questions please accept it as a solution and also give KUDOS.

Cheers

CheenuSing'

[dk_24]

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 · Accepted solution]

@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,