Forum Discussion
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 page with all information about that error.
On table visualization 40 columns with just one line didn't look good, with multi row card didn't look good either.
I try with matrix to put my table columns in the left and the values on the right, I think this is the best solution but I did not succeed.
So my table is like:
A B C D E
1 2 3 4 5
And I want it to be transformed in
A 1
B 2
C 3
D 4
E 5
Someone said that I can't do this because I can't have more data types on a column. It is this possible, and if is not possible how do you see a visual where I need to see 40 columns, most of them short text, date or number and 2-3 with possible long text. What component should I use?
6 Replies
- amitchandak
Super User
Not sure if this can work for you. But in Matrix, you have the option - show on the row. You measure will go on row. Try that can solve
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on LinkedinThere are some settings vet grid and horiz grid, and i try it but i coudn't make it, if you know how to do it please give me an example.
HI Valerica_G,
I think power query 'transpose' or 'unpivot columns' feature should suitable for your requirement, please take a look at following links to know more about them:
Regards,
Xiaoxin Sheng
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?
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
