Forum Discussion

Valerica_G's avatar
Valerica_G
Regular Visitor
6 years ago

View one line form a table pivoted

I have a table with more than 40 columns about some alarms, I have one visualization where I have a table just wit 10 most important fields of this table. So I what on drill through to open another p...
Need Help
Valerica_G's avatar
Valerica_G
Regular Visitor
6 years ago

So let-s say i transpose my table from power query, then i have a lot of columns having the name = with the id. Now how do I make a visual when used drill down to this to display the column with the table names and the column with the id that come from drill down? I dont think it is possible

Do you know any other method, or other third party visual that can somehow display one line from 45 columns in a nice way?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Valerica_G,

    I think 45 columns are too much to visualizations.

    In my opinion, I'd like to suggest you use unpivot columns to transform your value fields to attribute and value. Then you can simply create visuals with category, attribute fields as axis and legend, value tp value field.

    Regards,

    Xiaoxin Sheng