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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

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.

Top Solution Authors
Top Kudoed Authors