Data reporting question

[Mickeyfinn]

I am looking to create reports from an sql database. Very simple reports i believe. Most reports will come from a single table which contain records consisting of a location, parameter,Date and a value. I am looking to generate a report which is ran for a date range displayed down the left hand side of the page and data values that correspond to the location/parameter selected for the report. The result will look like a spread report. I wanted to do this in crystal, but ran into problems with having multiple record values displaying on the same line. Each record consist of the fields listed above and what I am looking to do is have headers across the top with 15 or 20 "location/parameters" columns and have the values in the column for each location parameter that has a result.

Ideas? Is power bi the way to go?

[mahoneypat]

Yes. A simple matrix visual with Location on columns and parameter on rows with Values in Values. Or you can put both location and parameter on column and drill down to show all the values.

Pat

[Mickeyfinn]

The picture above is the output I am looking for. Each column has a header indicating the Location/Parameter to be listed in that column. Each row is a date and each value for the selected location parameter is listed on the date row under the location parameter in the report. I am looking to set this up with approximately 15 or 20 columns of location/parameters and have the value listed on the row with each date that data is available. 

This picture is a copy of the data from Power BI. as you can see each line has an entry for location, parameter, date and value, although every date does not have the same set of location parameters. I am trying to have the report look at this dataset and give me the previous 45 days of data for the location/parameters that I have selected as columns in the report. 

Hope this helps

Richard

[Mickeyfinn]

Not sure if the output you described is what I am looking for. I want the final report to look like a spreadsheet with each date of the requested period listed in the first column with 15 or 20 other columns labeled with a combination of location and parameter. Each row will represent a date and any location parameter combination that I have a column set up will have the value on the row with the date. Each row may have a value for 1 or all of the columns or possibly there will be no data at all for some dates. There will never be more than one value for any date/location/parameter combination. 

Thanks again

Richard

[v-xiaotang]

Hi  @Mickeyfinn 

I just want to confirm if you tried solution mentioned by mahoneypat? And if you have resolved this question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

-

Attached the following questions:

What's your current data and what's the expected outcome? Could you show their pictures? It may be more intuitive and reliable to explain with pictures. 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.