Anyone help me to create dashboard with following sample data.

[mdaamirkhan]

Hello All,

Anyone can help me create dashboard report with following sample data. (similer as second sheet in the file using Data sheet as a sample data ).

I have shared the file in google drive link: https://drive.google.com/open?id=0BxreilNC4Avsb2pDb1l1UW1xNzQ

I have tried to create report similer as second sheet in the file using Data sheet as a sample data. But I cannot make it.

It will be very helpful if create a report and share the solution file.

It very urgent and important. 

Thanks in advance

Aamir

[v-qiuyu-msft]

Hi @mdaamirkhan,

The Data sheet in your Excel doesn't contain date field while the report you that has date values. You need to make sure the source data is useful firstly. 

Regarding the report, you can use slicer visuals to filter data. For All, Foods Infant Milk Formula table, you can use Matrix visuals to visualize data if you have date field. 

By the way, it would be better you go through the Power BI desktop features from here, then post a question in the forum where you stuck, rather than create a report for you directly. 

Best Regards,
Qiuyun Yu 

[mdaamirkhan]

I have share sample data again link: https://drive.google.com/open?id=0BxreilNC4AvscTBncE9fUGVrcGc

[v-qiuyu-msft]

Hi @mdaamirkhan,

Regarding your sample data, where are you stuck? If you want to get data from input sheet, you can use Excel data source in Power BI desktop to get data. 

Best Regards,
Qiuyun Yu 

[mdaamirkhan]

I have shared the pbix file link: https://drive.google.com/open?id=0BxreilNC4AvsVGV6dFk0R0RfMGM

I have Stuck to create Period column using "Month and Year column" and Also stuck to create Measure colunm where I want put only Name "Value and Volume" using value and volume.. 

I have also share output file of the excel which I want create similar report like sheet "36 Period per category" has.

link: https://drive.google.com/open?id=0BxreilNC4Avsb2pDb1l1UW1xNzQ

[v-qiuyu-msft]

Hi @mdaamirkhan,

You can create a calculated column:

Month and Year column = Milupa_Input[MONTH] & "."& Milupa_Input[YEAR]

To create a column named "Value and Volume"  contains values "value" and "volume", you need to know which rows corresponding to "value" and which rows match "volume" firstly. 

Best Regards,
Qiuyun Yu 

[mdaamirkhan]

I have created column = Milupa_Input[MONTH] & "."& Milupa_Input[YEAR]

but it showing "1.2015"  how will I show Jan 2015 instead of 1.2015

If I selcet Value then it will show Value figure and If I selct Volume then it will show Volume figures.

e.g- create a column named Measure inside that there will Value and Volume  screenshot. 

I want Category list hierarchy screenbelow there are "Category 1,2,3 and 4"

How will I create/show Category 1,2,3 and 4 in dropdown

In the screenshot its only Category 1 

[mdaamirkhan]

Any update on below query ?

[mdaamirkhan]

If I selcet Value then it will show Value figure and If I selct Volume then it will show Volume figures. In my sample data pbix file there no column Measures. 
e.g- how will create a column named Measure inside that there will Value and Volume screenshot.

I want to create one Dynamix Change Axis in my report with "Value and Volume" If I select "Value" then it will show Value figures and
If I select "Volume" then it show Volume Figure . Can you please me on this I have shared the pbix file link: https://drive.google.com/open?id=0BxreilNC4AvsZE5pQWFfdzBfZEE

[mdaamirkhan]

I have replied few time regarding the below update. I didnt get any update is there anyone else who can help me on this.

Its bit urgent and important.

[mdaamirkhan]

any update ? I am stuck please help me 

[mdaamirkhan]

PLease help me I am stuck ?

[mdaamirkhan]

any update ?

[pnvinod]

Hi,

 Are you able to import data (Get data) and save and create a pbix file?

If yes please share the file and let us know where you are struck

Vinod

[mdaamirkhan]

Can anyone help to create the sample I have tired but cant please help me.