Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Mickeyfinn
Frequent Visitor

Data reporting question

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?

4 REPLIES 4
mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Mickeyfinn_0-1648153080292.png

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. 

Mickeyfinn_1-1648153334053.png

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

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

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.