Skip to content

10AM–5PM by appt.
24h urgent appts

📞 0279-088880

All prices include GST

Cart
0 items

Computer Repair Guides

Read a Power BI Highlighted Bar Without Treating Its Faded Remainder as Removed

by AEPC / AKL East PC 28 Sep 2026

After selecting a category in one Power BI visual, another bar may become partly bright and partly faded. The faded region is meaningful context, not proof that those records were removed from the chart. Read the interaction before reporting the apparent total.

Use a report whose source and intended filters you understand, preferably a local practice copy. Pick a bar with a known total of 100 units, of which 30 belong to a category selectable in another visual. Keep a small supporting breakdown so you can identify the selected contribution independently.

Separate the whole bar from the selected contribution

Power BI cross-highlighting keeps unrelated data visible but dimmed. Cross-filtering instead removes unrelated data from the affected visual's displayed result. Visuals do not all behave identically, and the report author can configure their interactions. A selection's effect therefore needs to be checked on each visual you intend to quote.

Select the category associated with the known 30 units. In a cross-highlighted bar, inspect the highlighted contribution against the full bar and read the available value labels or tooltip carefully. The 100-unit total and 30-unit selected part answer different questions. Do not assign the same meaning to both merely because they share a chart position.

In the practice report, compare a related visual configured to cross-filter. Its displayed subset should describe the selected records, rather than retaining the unselected portion as a faded background. Reconcile that subset with the supporting breakdown before treating its value as confirmation.

Preserve the selection context in the explanation

Try a second category with a different known contribution. Confirm which marks change and which remain as context. If an unrelated visual stays unchanged, inspect its interaction or filter setup instead of assuming it also describes the selected category.

To remove a highlight, select the chosen value again or select empty space within that same visual. Check that the initial context returns. Other report, page or visual filters may still be in force; clearing one visual selection is not a claim that the whole report is unfiltered.

When sharing a static image, explain both the selected category and whether the chart retains the overall context. A recipient cannot click the selection to discover what the fading means. The useful outcome is a value tied to an explicit population, with the selected contribution and retained total distinguished wherever both remain visible.

Sources: Microsoft: cross-highlighting.

Prev Post
Next Post

Thanks for subscribing!

This email has been registered!

Shop the look

Choose Options

Edit Option
Terms & Conditions
Unless otherwise stated, brand new accessories are guaranteed for one year. Second-hand parts are guaranteed for three months. Repair (hardware) is guaranteed for one month. The software is not covered by the warranty, you should contact the software development organization for technical support and after-sales service. The warranty is limited to the same position fault; the customer should provide the warranty with the complete Warranty sticker and the receipt of payment. Otherwise, it will not be guaranteed. (If the warranty label is damaged for any reason, is not covered by warranty.) Returns and refunds Please read our Return & Refund Policy for the current return timeframe, conditions, fees, return methods and refund processing time.
this is just a warning
Login
Shopping Cart
0 items