locked
Powerview Axis and Measures RRS feed

  • Question

  • I'm trying to create an Excel Powerview scatter plot with a $ amount on one side and measure showing the % change from previous year on the other. 

    Q1) But for some reason the axis is showing up to 1000% but not bubble anywhere near there. Why is that?

    Q2) I want to therefore filter the x-axis to only show 0-100% but cannot add my measure to the filter pane. So how else do I limit the chart to show only the 0-100% range?

    Other info:

    The measure was calculated using num 6 here: 

    https://sqldusty.com/2015/09/01/10-dax-calculations-for-your-tabular-or-power-pivot-model-part-1/

    Sunday, March 13, 2016 4:31 PM

Answers

All replies