cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Report view: Visualisation of Cards as static & publishing question

Hi Experts

 

I created in the report view, I have some card visualizations. Please can I make this cards which are like Totals and other sub totals static and always displaying instead of getting filtered based on my selection in other chart visualization.

I have disabled, cross reference etc but that has no impact 

 

2. I published report via workspace and email ID to share. I changed the alignment in the my main reports and refreshed in the published link report (Sent to myself). I am not having the latest view in the published view. I want my published view to be dynamic wrt to data and reports, please advice. 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Correct.  You can create a measure with ALL*() functions that are designed to remove filter context. For example all orders in an order table, regardless of any filters the user may set.

 

In fact, since the numbers do not change, you can create calculated columns instead. Those are only computed once, during dataset refresh.

View solution in original post

4 REPLIES 4
Highlighted
Super User II
Super User II

Create new measures to feed your cards. These measures can be designed in a way that they ignore filter inputs.

Highlighted

@lbendlin Thank you, Please can you kindly send me options in screenshot, While Total is not a display in other visuals, that is static? while I share same measures in other visuals, I see filters changes impact the display.. 

 

So let me see, if I got you right, cards with mesures which are not shared by other visuals, so that it is not impacted by filters OR measure have settings, which can disble the filter ?

Highlighted

Correct.  You can create a measure with ALL*() functions that are designed to remove filter context. For example all orders in an order table, regardless of any filters the user may set.

 

In fact, since the numbers do not change, you can create calculated columns instead. Those are only computed once, during dataset refresh.

View solution in original post

Highlighted

@lbendlin Thank you, I will try this. Cheers mate

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors