Forum Discussion
Data reporting question
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
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