cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: How to filter on a card - works in table view

@JacobPBI  - I'm not sure what exactly you're looking for. Previously, you stated that you wanted the line graph to add up to the Card. Could you describe exactly what you want the measure to do? Specifically, if there are 2 different months with 5+, what would you want to happen?

 

JacobPBI Regular Visitor
Regular Visitor

Re: How to filter on a card - works in table view

Hi @natelpeterson . Thank you for responding!

As an example i have included a picture:PowerBIDoubleCount.PNG

As you can see when i choose a year and a period (multiple month selection) the sum of the line graph is higher than the KPI. This is due to the reason you explained. I would like the linegraph to only count a unique app id once in the period i filter on.

Do you think this is possible and/or do you have an idea how to do this differently?

Super User
Super User

Re: How to filter on a card - works in table view

@JacobPBI - I suppose it's possible - would you want the earliest month with +5 to contain the user, or the last month, or month with the most usage? 

I'm concerned that this will not provide an intuitive result.

Also, why are there 2 different line graphs? It appears they're both showing the same information.

 

Cheers,

Nathan

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 76 members 1,207 guests
Please welcome our newest community members: