Forum Discussion

vcmoffatt's avatar
vcmoffatt
Frequent Visitor
9 years ago
Solved

percentage slicer

Hi,   Is there a way of creating a percentage slicer. For example I have a set of data that shows the forecast Revenue, but I want to be able to add a slicer that adjusts the forecast based on a pe...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    No, the idea of a selection based table is that you can get your measures to check the filter context of the selection table and alter their output accordingly.  The use of "MIN" or "MAX" handle that while you expect the table to only ever have a single row, it also covers when nothing is selected

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi vcmoffatt,

 

Currently, there is a confidence interval option under Analytics pane, the appearance of forecast revenue will be dynamically changed depend on the selected value. However, this is the only way to change the confidence percentage, it is not available to move it into a slicer. 

 

Best regards,
Yuliana Gu

  • vcmoffatt's avatar
    vcmoffatt
    Frequent Visitor
    9 years ago

    Thank you v-yulgu-msft what charts is the forecast option on, as I don't seem to have it?

     

    thanks

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi vcmoffatt,

       

      The forecasting feature applies to line chart visual.

       

      Regards,
      Yuliana Gu