Turning a Table

Question

Hi together,&nbsp;I am new at Power BI. I am looking for an solution for following problem:&nbsp;My sql&nbsp;tabel looks like this:&nbsp;Alarm_1 l Alarm_2 l Alarm_3 l Alarm_41&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; l&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l&nbsp;1&nbsp;I want to visualize the alarms with Synoptic Panel OKViz but this tool needs the data in this structure&nbsp;Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ValueAlarm_1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1Alarm_2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0Alarm_3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1Alarm_4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;What can I do to fix the problem?

greg_deckler · Accepted Answer

In Power Query, unpivot your columns.

Forum Discussion

Turning a Table

1 Reply

Related content

Turn off navicagtion pane

Turn on Copilot in Power BI

Matrix Table turn off Sort

Peristsent filters - turning itself off each publish

Shortcut transformations: Turn files into Delta tables without pipelines (Generally Available)