Hello all,
I'm trying to give some independance to users by giving them the possibility to create their own power BI report based on a SQL query that they can customize.
Basically, the result of the query is :
- one column of "datetime" with datetime value
- n columns of "sensors" (flowmeters, thermometer ...) with numeric values
=> sensors columns may vary, depending on the SQL query, from 2 to >100 columns.
And the visuals on Power BI should be quite simple : bar/line chart with :
x = datetime
y = measure based on 1 sensor, with the possibility to show several measures
=> I want to avoid creating measures automatically : because of the numbers of measures possibles (>100), and also because the list of sensors will always vary.
=> I'm trying to generate automatically measures for each sensor (so for each column) by selecting it through a slicer. Do you think it is possible?
Many thanks for your help, i didn't find any solutions in the forum and on the web (nor chat gpt ;))
| date | sensor 1 | sensor 2 | sensor 3 |
| 01/01/2023 | 1 | 8 | 3 |
| 02/01/2023 | 7 | 1 | 10 |
| 03/01/2023 | 2 | 9 | 10 |
| 04/01/2023 | 2 | 9 | 5 |
| 05/01/2023 | 9 | 5 | 10 |
| 06/01/2023 | 3 | 1 | 5 |
| 07/01/2023 | 7 | 9 | 6 |
| 08/01/2023 | 9 | 8 | 2 |
| 09/01/2023 | 9 | 8 | 4 |
| 10/01/2023 | 5 | 4 | 5 |
| 11/01/2023 | 10 | 2 | 9 |
| 12/01/2023 | 7 | 2 | 1 |
