Forum Discussion
Line chart with values showing up twice
Hello - I created a chart that allows me to essentially have a "double" X axis. There is a custom visual that does this, but it is able to be created without it if you set up things correctly (I learned after getting the custom visual and then seeing a big X in the Power Bi service and learning that our company did not allow non-certified visuals). Fun!
The issue I am having is that if I drop a measure into the line values, the value of that measure shows up twice (once over the "projected" series, and again over the "actual" series. For example, the measure that results in $9,274,628 should only be showing above the "actual" column and should not show up over the "projected" column. Any help is appreciated!
4 Replies
- parry2k
Super User
Anonymous it is not clear what you are trying to achieve, if you simply put your measure/sample data and the expected output, it will help to provide a solution.
Hopefully there was an image that was in my first post. I get the feeling sometimes the images don't show up. I am using Edge browser so one would hope so. The image makes it pretty clear what the issue is. Here is the current measure represented by the blue line.
SumX Total Shipped = [SumX ERP Shipped]+[All Unforecasted Totals]+[SumX Forecasted Shipped]In the image (posted again), the value for this measure is showing up on top of both columns. Projected and Actual.It should only show on top of the "Actual" column as that is what the measure is summing.- parry2k
Anonymous well these images and dax don't explain much, it will be easier if you share sample data and what is the model and what are those measures (share expressions). it is not easy to look at the image to make out what is going on when you are using measures, seem slike measure is returning the value and removing the filter context.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
