Forum Discussion

TanHY's avatar
TanHY
Helper I
2 years ago
Solved

Power BI Table Visualization

Hi guys, I have a query when I trying to understand more about the power bi visualization. As you can see from the 3 attachments, first is my testing csv data, second and third are my data visualsation in power bi.

My doubt here is, am I able to display title and type only , but I wanted to show all the 4 rows. As power bi default setting, it will group the same name data togetherHopefully can get some fruitful advice from you guys. Cheers

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi TanHY 
    All visuals of Power BI work with the aggregating logic (like the pivot in Excel).
    To show all the values you should put at least one value that is unique.

    For example, you can add an index column and use it:

    File with an example attached.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi TanHY 
    All visuals of Power BI work with the aggregating logic (like the pivot in Excel).
    To show all the values you should put at least one value that is unique.

    For example, you can add an index column and use it:

    File with an example attached.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly