Forum Discussion

prashett7's avatar
prashett7
Frequent Visitor
2 years ago
Solved

Measure to Calculated Column

Here is the snap shot of the visual.   I have a slicer to select the start date and end date. I want to have similar slicer (Slider with min and max) for filtering the avg revenue per day. Also, sl...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi prashett7 ,

    Sorry, there is no workaround.

    In Power BI, the slicer value must be a field value, but you need it change according to another date slicer, it could not be achieveable .

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi prashett7 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting.

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

prashett7's avatar
prashett7
Frequent Visitor
2 years ago

I would like to include a slicer for avg revenue per day. Currently it is a measure and I cannot use a measure as input for a slicer. I'm not able to get the accurate average in a calculated column.

 

Let me know if you still have any questions.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi prashett7 ,

    Sorry, so far, to my knowledge, this may not be achieveable.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • prashett7's avatar
      prashett7
      Frequent Visitor
      2 years ago

      Any work around can you think of?

       

      Even if we get to a close number in calculated column, we can use it for slicer and we can use the measure in the table.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi prashett7 ,

        Sorry, there is no workaround.

        In Power BI, the slicer value must be a field value, but you need it change according to another date slicer, it could not be achieveable .

        Best regards,
        Community Support Team_Binbin Yu
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.