Search Microsoft Fabric Ideas

Power BI

Allow for trend lines with small multiples on line charts

The moment you add a small multiple value to a line chart you lose the format option of trend line. I would prefer to be able to show the trend line by category (small multiple).

Power BI

Improved filter/cross-filter functionality and formatting options for line charts

Currently if you filter a line chart from the legend it de-emphasises the unfiltered series by adding transparency (good); brings the filtered series to the foreground (good); but adds data markers which can really detract from the visual or even worse, completely obscure the trends if there are lots of points (bad). I would like the option to choose formatting when line charts are filtered...including an option to set a default colour (likely light grey) for all unfiltered series, in order to really highlight the filtered one(s). I'd also like this to work with crossfiltering. Currently you can't cross-filter a line chart from another visual as per related idea at https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32540377-line-charts-should-allow-cross-filtering-to-other But this results in inconsistencies with other visuals, and means we may be forced to retain the legend in a line graph when we don't want to. (I often use a bar chart as a legend for other visuals that CAN be crossfiltered, as outlined here: https://twitter.com/InsightsMachine/status/1218638496664936453 Here's a twitter thread on this with images: https://twitter.com/InsightsMachine/status/1219021672742735878

Power BI

Small multiples - Pie and Line & Clustered Charts

The new Preview Small Multiples option for the Bar and Line charts is fantastic. Expanding this to Pie charts and Line & Clustered Charts would make this even more useful to tell data stories when comparative views are needed

Power BI

A chart created with small multiples when filtered it is limited to that small space than to show up to the whole chart area.

Here I would like to suggest an idea on the small multiple section in Charts. I have created small mutiple with a layout of Rows: 2 and Columns: 3 therefore we will have 6 charts in 6 area (of small multiples). Thus to show the whole data the chart will display in small multiples and easy to read. However, when filtered to any selection in slicers, it then filters down and shows up only one chart on the top left corner leaving the other areas blank. This ideally gives a wrong impression as data is missing or something went wrong on the visuals.

Suggestion: When selected filters/slicers The data has to be displayed as a normal chart occupying the whole chart area without leaving any blank spaces.

Power BI

Line Charts should allow cross filtering to other elements on page

currently if I have a bar chart and select a data element other charts on the page filter accordingly. This does not work with a line chart. It would be great if cross filter functionality worked the same on line charts as it does on bar charts

Power BI

Small Multiple Line Chart with Auto-Adjusting Y-Axis

Trying to show growth in similar groups of people but with vastly different sizes means that showing them on the same line chart tends to hide trends in groups with smaller numbers. There is a custom visual Small Multiple Line Chart which starts to address this by being able to split one chart into several by a specific factor, such as Country, but the Y-axis is static across all of the small multiples so the problem persists where, say, a country with a small population will have an almost flat meaningless trend line if it's in the same dataset as a large country with a high population because of the scale. I'd like to see a standard visual developed to allow small multiple line charts but where the Y-axis can be set to either be fixed (as in the custom visual) or auto-adjusting so that each small multiple might have a different range to allow trends in smaller populations to be seen more clearly.

Power BI

Small Multiples - Pie & Line and Clustered Chart

The new preview 'Small Multiples' as a great addition. It would be very helpful when telling data stories that require comparative views to have this option added to Pie and Line and Clustered Charts

Power BI

Cross-highlighting for scatter/line/other charts

Cross-highlighting is not available for many charts, especially scatter and line charts. Only cross-filtering is available to all. This is needed for data analysis and it's is obviously doable since some paid custom scatter visuals have them.

Power BI

Apply cross filter through multiple pages

Please apply the possibility of cross filtering over multiple pages. E.g. cross filter a year on a bar chart on page one and at the same time on page two the year is selcted on a matrix table. Basically it is the same function that already exists with the sync filter.

Power BI

Y-axis constant line differentiates with small multiples

In Power BI Desktop for RS may 2022 the Y-axis can be used with a field value. But unfortunately the line doesn't differentiate when using small multiples. So the line is the same in all line charts, whereas I would expect it to be different for every line chart, based on the small multiple.