Forum Discussion

Eli_'s avatar
Eli_
Frequent Visitor
6 years ago
Solved

How to change How Table appears

Hello all,   I would like to change how my table appears, not sure If I need to make this change by using a new visual or by doing some more transformation in the query editor.   Here's how it cu...
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello Eli_ 

    Rather than unpivoting your data you can write a measure to calculate the value to display then add the No field as the column, put the measures if in the values and set the values to display on rows.  That way you can format each measure individually.  My measure names start with 'm_' just bacause you can't have a measure and a column named the same.

    I have attached my sample file for you to take a look at.

     

    If this solves your issues please mark it as the solution. Kudos 👍 are nice too.

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

Hello Eli_ 

Rather than unpivoting your data you can write a measure to calculate the value to display then add the No field as the column, put the measures if in the values and set the values to display on rows.  That way you can format each measure individually.  My measure names start with 'm_' just bacause you can't have a measure and a column named the same.

I have attached my sample file for you to take a look at.

 

If this solves your issues please mark it as the solution. Kudos 👍 are nice too.

Eli_'s avatar
Eli_
Frequent Visitor
6 years ago

Hello jdbuchanan71,

 

Thanks for helping on this the last time. Please there's still one more problem I'm facing.

When the "No" column is duplicate in the Table, it sums up in Matrix Visual.

See the No  1 has two records, I have set Summarization to Don't summarize. But I still get the Result below.

 

How do i prevent the summiraztion, and have 2 individual (No. 1) and not 1 Summarized one ???

 

See the Table

 


See the Matirix Visual result