Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi there,
i have a table that contains 3 columns
1 - "Conteggio Scontrini" -> trad: Count Receipts
2 - Date
3 - "Carta" -> Fidelity Card No_
Each row shows how many receipts were issued that day for that fidelity card.
I would like to have from this table a representation something like Pivot.
Example below in Excel.
So, how many fidelity cards have a receipt, how many 2, how many 3, etc etc etc.
Taking the dates into consideration, it must therefore be not static but dynamic data
Please help me
All the best
Hi @Z_BI ,
In the report view select matrix or table in visualization and add Conteggio Scontrini,Carta in columns. Then right click on feild and select "count". similarly you can add filter from visualization, add date into it.
Thanks
Hi @Mani_1 ,
thnx to reply.
If I do what you show me the results is not good.
Applicated COUNT in "Conteggio di carta". I need to have "COUNT RECEIPES" divied
1
2
3
4
etc etc
Sure, here below.
Table dates
In report, at the moment, i have this visual
Field "Carta" - no summerize
Filed "Conteggio Scontrini" - SUM
my need, in a simpler way, is to answer this question: "in a given period of time I select how many loyalty cards have had a receipt? How many 2? and so on....
Let me know if you somenthing
thanx for your support
All the best
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |