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,
I have a 3 dimention data like "Product"-"Year"-"Sales", I use to have a matrix data view for it, where "Product" as row, "Year" as coloum and "Sales" as value, sometimes there are mutiple records for sales so I use the "max" or "first" option to summarize it.
Recent I met a strange problem, if I remove "Sales" from Value, then try to drag it back like before, it's not working, I was simplely not able to dray "Sales" into value, I also tried drag it to coloum or row then use the move option to move it to value, then the Power BI start to no response at all and I have to close and reopen it. I tried reinstall Power BI and restart computer, nothing works.
Then I realize it was the problem at summarization because if I create a card for "Sales", normally it will be summarized and shown, but now I also not able to drag it into the value.
I also tried some other data, all same problems, seems like the summarizarion feature is dead in my report.
I created a new report and use the exactly same data to create a matrix like before, works fine, so the problem only happends to my old report 😞
I did a lot of research and no clue get, please help me 😞
@JiapengSun , In a matrix when you drag a column on Row/Column you will not get summarize option. When dearg to values you will get. Now if you have created a measure it will not show summarize option. Or if you have set up it as not summarized in Column tools, it might not get dragged to values.
Hi!
Thanks for the reply, it's not a measure and I tried set it to some other options than "not summarized", but nothing works..
User | Count |
---|---|
121 | |
69 | |
67 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |