Katrin on 3/2/2017 4:00:46 PM
Power BI
Legend as a filter of the graphic itself
I would love to use the legend of a graphic as a filter for the graphic itself. For example when I've got a line chart with a legend and some lines have got much bigger values than the others, I hardly can see the other lines. So I prefered to click on the legend to select the shown lines so, that the y axis changes automatically and I can compare the lower valued lines. At the moment I only can use the legend to filter other graphics but I would like to decide what happens with the graphic itself.
David Hartell on 10/6/2015 4:43:31 AM
Power BI
Ʃ Values as Legend or Axis as in Excel
In Excel you have four sections where you can add column data: Ʃ Values, Axis (Category), Legend (Series), and Filter. Into the Legend and Axis sections you can add Ʃ Values. In which case if I have 2 value columns A and B the Axis points would be A and B. Hopefully this makes sense, or you could try it out in Excel.
石川曜詩 on 11/11/2019 5:47:09 PM
Power BI
The order of the attribute values on the legend
Hi, I noticed that when one makes a 100% stacked bar chart in PowerBI and positions the legend to go on the right, the order of the attribute values are reversed in the legend. For example, if the attribute values in the graph were ordered (from top to bottom) A, B, C, the legend would be C, B, A (again, reading from the top). It would be easier for everyone if PowerBI could make the default order of the legend match with that of the graph; could Microsoft consider fixing this issue?
RF 1991 on 3/27/2021 8:32:19 AM
Power BI
Legend independency from Values
Right now legends are dependent to values. it means that the value is assign to them. is there any possibility to make that independent? like get Legends from another table?
Marion Berg on 1/8/2024 3:32:30 PM
Power BI
Line chart tooltip filter with legend
It would be great if the data point you are hovering over would actually filter the tooltip instead of getting the tooltip just from the X axis in a line chart with legend. This way you can easily get detailed information of the exact line item you are currently hovering over instead of all items sharing the same value on the X axis.
If on day X there have been purchases by three customers (each customer is represented by a line) then I want to see more details of the one purchase I am hovering over via tooltip instead of getting all information for the purchases by all three customers. There is only so much space you can use in a tooltip and being able to streamline the filtering that is passed to the tooltip page would be a huge help.
Jordi Frijters on 8/23/2017 2:33:30 PM
Power BI
Dynamic selection of legend & value in charts so users can customize charts
It should be possible for end-users to customize the chart legend & value, based on several options provided by the developer of the report. For example in a datamodel with Sales and Net Sales as measures and Channel and Country as columns a developer creates a report showing a chart with sales over time with Channel as the legend. The developer should be able to let the user change the measure to Net Sales and the legend to country so the chart will show Net sales over time with Country as the legend. A user is now able to customize their chart(s) instead of only filtering based on slicers or filters. This greatly improves the usability and reduces the need for multiple charts or even pages.
jerome P on 4/11/2018 1:02:47 AM
Power BI
interaction with chart: ignore the legend in cross filtering
When I make my chart interactive to filter other elements on the screen, the filter applied is both on the column + legend axis. I want to ignore the legend from the filter. for example: I have a stacked column chart with number of events by week and status in legend. when I click on the chart this selects both the week and the status, but only the week is relevant for my interaction. I'm displaying the same measure in other visualizations on the screen, but the status should not be filtered.
AnneC on 6/21/2018 8:44:20 AM
Power BI
Displaying legend sorted by value or count depending on filter selected
I am a new user, and we use graphs to view data over several years in a ribbon or bar chart. At present the legend only sorts alphabetically, unless altered manually or by formula. We would like to be able to have the legend order sort and display automatically to directly reflect the graphic depending on the year selected in the filter. The graphic sort by, is sort by x, but this is not reflected in the legend.
Rohini P on 2/16/2021 5:35:11 AM
Power BI
Legend with multiple values in all bar and line charts
In all bar and line charts in Power BI, at present we can use only one value with a legend. If we add two values in the values field, then we cannot use legend value. We need to use multiple values split using legend value. This method will be useful for comparing values.
Alon on 12/14/2016 5:16:31 PM
Power BI
Select the order of values/legend in a visual
Select the order of values/legend in a visual, not alphabetical or by value size but by our own needs.