cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
maca128 Frequent Visitor
Frequent Visitor

new to power bi, pivot.

Hi experts,

 

I have a dataset like this in management studio:

delete.jpg

 

I’m new to power bi… 

 

I want to allow the user to play with the data as the much as he/she wants… probably the user will want to, know the count of a given Id for a certain month… or just a total count of that member Id.

 

 

How can I create something interactive like that?

3 REPLIES 3
Super User IV
Super User IV

Re: new to power bi, pivot.

@maca128No problem. It is easy. First and foremost, do you know how to connect PowerBI with your data source ( I assume it is SQL Server)?






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





edejes2
Advisor

Re: new to power bi, pivot.

Hello @maca128

 

I will put those into filters and a count of ID's in a card.

 PowerBI Tweett - Power BI Desktop.jpg

 

Regards!

ED

maca128 Frequent Visitor
Frequent Visitor

Re: new to power bi, pivot.

Hi!!

I would need a bit more details, I have some experience but only with ‘report builder’ for SSRS, this is completely new to me.

 

I wanted to display it as

 

member id

xxxx

yyy

 

(and when the user clicks on the xxxx yyy, display:

                lesson passed   unit passed

jan                2                          3

feb                3                         3

mar

apr              …                        …

may

 

delete.jpg

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors