Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
acerNZ
Helper III
Helper III

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

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
lbendlin
Super User
Super User

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

@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 ?

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.

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.