Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

got dinamic graphs and tables

Hello, If I have below table "Alarms":   ID          Alarm1              Alarm2 ------------------------------------ A              no                       yes B              no               ...
Custom Visuals
Dashboards
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Anonymous

     

    You can unpivot the columns o Alarm1 and Alarm2 in Query Editor, and then filter the column to leave yes only.

     

     

    Then you do not need to create any measure and can get the desired result as below. For details, please refer to attached PBIX file.

     

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Anonymous

 

You can unpivot the columns o Alarm1 and Alarm2 in Query Editor, and then filter the column to leave yes only.

 

 

Then you do not need to create any measure and can get the desired result as below. For details, please refer to attached PBIX file.

 

 

Best Regards,

Herbert

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Awsome. It worked very well :D