Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with values in table visualisation

Hello all   I have data sitting in 2 data tables as below:   Table 1 Date         Till     SalesOpening 1/9/2019  AO1   45 2/9/2019  AO1   78   Table 2  Date          Till    SalesClosing ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    you can change the Data Type  to text 

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

All visual in Power BI implicitly group your data, to see an individual record you need to add record id or Index value to both main table and later visual table.  

you can add index in query editor as below.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you Mariusz 

     

    How would you then use the Idex column in the resulting table visualisation though?

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi Anonymous 

       

      you can change the Data Type  to text 

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      Mariusz Repczynski