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 |
User | Count |
---|---|
117 | |
63 | |
61 | |
41 | |
40 |
User | Count |
---|---|
117 | |
66 | |
66 | |
65 | |
50 |