Forum Discussion
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 change.
required output :
sample fields : Order ID( ForCount), Order Date.
https://drive.google.com/file/d/0B5BkbOE1GSWHUXBLVm1NX0FzZzg/view?usp=sharing
Thanks,
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,
3 Replies
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,
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,
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'
