Forum Discussion

telesforo1969's avatar
telesforo1969
Icon for Helper V rankHelper V
3 years ago

Do not group the same date

I have a table with two columns: date and Cost. several costs have the same date, I don't want them to be grouped by date. I want to reproduce the same table in PowerBI,      
Need Help
telesforo1969's avatar
telesforo1969
Icon for Helper V rankHelper V
3 years ago

it's not possible if i don't add another column? I would not want to add a third variable to present the repeated values. I can see from Padycosmos's solution that it's possible, except he's hidden a third column.

Padycosmos's avatar
Padycosmos
Icon for Solution Sage rankSolution Sage
3 years ago

I have no hidden columns. Could you please check whether Do not summarize is on for the date column , and the id report column as  well?

  • telesforo1969's avatar
    telesforo1969
    Icon for Helper V rankHelper V
    3 years ago

    is correct, both columns is activated "Do not summarize"

    • Padycosmos's avatar
      Padycosmos
      Icon for Solution Sage rankSolution Sage
      3 years ago

      I hope your visual is a Table visual and could you please share your pbix file, if the data is not sensitive?

      • telesforo1969's avatar
        telesforo1969
        Icon for Helper V rankHelper V
        3 years ago

        I don't see the option to attach file.  What would be the option to share the file?