Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to create a report like as shown in the image. The data source is an sql server with data mode as direct query. The result of the query repeats the rows for sales person and area for each customer. I need to group the rows by the sales person and area and have the data as the group header. For each group row, the customer names and order amounts are the detail rows. The details rows need to be displayed by default and not as drill down. Such a format was possible in crystal reports. Is it possible with Power BI. I tried using table and matrix visualization types but couldn't do it
Hi @shaun1,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
Hi @shaun1,
This visual looks very simple. What's the structure of your data mode? Can you share a little sample?
BTW, if there is a hierarchy existed, the drill down is there by default.
Best Regards,
Dale
This is the shape of my data in data mode. Also I need to accomplish the mentioned report structure without drilldown.
Hi @shaun1,
I'm afraid the Drill down is enable by default. The Matrix visual has the effect.
Best Regards,
Dale
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |