Clarke on 09 Sep 2015 05:51:53
We should be able to put two values and a legend on the same line chart.
- Comments (99)
- Merged Idea (1)
RE: two values and legend on line chart
Come on guys tableau has had this feature for 2 years ! also there the same "Microsoft Idea" with almost as many upvotes.... https://ideas.powerbi.com/ideas/idea/?ideaid=2babef68-dd13-4a8b-bf48-ad829a297ea6 ...
RE: two values and legend on line chart
Totally agree, I think it is a must have
RE: two values and legend on line chart
Would improve a lot of dashboards!!
RE: two values and legend on line chart
Please add this feature. This is long overdue. It's time PowerBi catches up to Tableau regarding the customization of its default visuals.
RE: two values and legend on line chart
This feature is needed
RE: two values and legend on line chart
Like the other guy said, needed ASAP. Here's another example: let's say you have 2 min and max thresholds defined as constant per some product in a DimTable. The Fact table contains the product details: ID, cost, etc, but not these 2 threshold values of min and max, which are different for each product AND do not represent the minimum or maximum value as computed by a MIN() or MAX() function--let me repeat it again: these values are the minimum and maximum threshold of a series of values (for ex, the min and max temperature a device can operate at, so you will have values greater and lower than these 2 min and max values that come from a DB Dim table), and these need to be displayed as 2 horizontal lines on a Line Chart when the y-axis represents temperature, for ex.
Currently, if we stay with the example given, you can only map temperature values onto the Y-axis from the Fact table but not the min and max values from the Dim table AT THE SAME TIME. If you want to do this, you need to start messing around with DAX and create 2 calculated columns in the Fact table that will receive the min and max values for each row item. The Fact table keeps growing every day and so the duplication of values from these 2 calculated columns is just adding to the table size, regardless of how good the Vertipaq or xVelocity engine is. In other words, it's not an elegant solution.
The elegant solution is to be able to just drag and drop value items that have the same scale from different tables onto the same line chart.
Also, having another choice than just Linear scale, such as Log scale, would be a nice feature.
RE: two values and legend on line chart
WE NEED IT NOW
RE: two values and legend on line chart
Please add this feature! It would be super helpful especially with calculation groups. Unfortunately I can't add more than one value, making my calculation groups nearly useless in visualizations
RE: two values and legend on line chart
This should be a feature, incredibly limiting when looking at larger data sets.
RE: two values and legend on line chart
It's hard to believe this is missing in 2020 still. Make it happen and the PBI community will join to "Mexican wave" (ref. world cup 1986) traveling around the globe.