Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi together,
I am new at Power BI. I am looking for an solution for following problem:
My sql tabel looks like this:
Alarm_1 l Alarm_2 l Alarm_3 l Alarm_4
1 l 0 l 1 l 1
I want to visualize the alarms with Synoptic Panel OKViz but this tool needs the data in this structure
Name Value
Alarm_1 1
Alarm_2 0
Alarm_3 1
Alarm_4 1
What can I do to fix the problem?
Solved! Go to Solution.
In Power Query, unpivot your columns.
In Power Query, unpivot your columns.
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |