Hi @philthegaps ,
My original data table is the following table.
Select the colour column, then select the pivot column, in the message box, select Fruits for the Values column and "count all" for the advanced options.
Then you will get the result:
At this point, you get a colour-based count.
If I have misunderstood you, you can share the pbix file that wipes out sensitive information and the expected results.
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes I think you misunderstood me. I don't want a solution with M or DAX, but a "direct" solution with the Table/Matrix visual.
But I think there is no alternative so far, I have to use Dax or M.
@philthegaps not sure why you want to do this and what is the rational behind this. If you don't want to create a column or measure (you should write measure), in this case, you need to pre-aggregate in Power Query and then just visualize it.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.