The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a report report from a live connection to analysis services.
My report is a simple table like the following
category Measure
A 1
BB 4
B 4
C 2
D 3
I Want to show the category in the following Grouped form
category Measure
A 1
B 8
C 2
D 3
This would be easy when connected to an excel/csv file i would just create a calculated column.
How could i do that since when connected to a live connection i can only create calculated measures?
Can i somehow group the categories?
Hi Greg_Deckler ,thanks for the quick reply, I'll add more.
Hi @imarkopoulos ,
Did you mean to enter 'B' here? If yes, you just need to create the visual object as shown below.
If not, as Greg_Deckler said, switch 'Live connection' to 'Direct query' here.
Best Regards,
Wenbin Zhou
@imarkopoulos Switch to DirectQuery and add a local model?
User | Count |
---|---|
37 | |
14 | |
12 | |
11 | |
8 |
User | Count |
---|---|
49 | |
36 | |
22 | |
21 | |
18 |