Forum Discussion

Akhil_1411's avatar
Akhil_1411
Helper IV
6 years ago

Measure to Column Conversion

Hi All😊   I am trying this from one week but not getting appropriate results.😥 I wanted to convert measure to a column since end user wanted to use as a slicer. In my report i need to show four ...
General Comment
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Creating a calculated column formula will not be a good idea simply because those formulas do not update when a user changes a slicer setting.  If you are willing to see your measure in a slicer with bands such as 0-25%, 25.1%-50%, then share those bands with me.  Share a 3 column table - lower limit, Upper limit and the "text as it should appear in the slicer".

  • Akhil_1411's avatar
    Akhil_1411
    Helper IV
    6 years ago

    Ashish_Mathur ,

     

    Thanks for your reply. Ya, i know.

    Okay. Below is my range criteria that to be used in the slicer and that needs to dynamically change with the other slicer changes.

     

    CriteriaLower LimitUpper Limit
    0 - 10010
    10-201020
    20-502050
    50-10050100

     

    Thanks,

    Akhil.

    • Fowmy's avatar
      Fowmy
      Super User
      6 years ago

      Akhil_1411 

      I have added the range table and modified the measure to so when selecting a value from the range table, it will filter and show only the relevant records.

      You can download the file: HERE



       

      ________________________

      Did I answer your question? Mark this post as a solution, this will help others!.

      Click on the Thumbs-Up icon on the right if you like this reply 🙂

      YouTube, LinkedIn

       




    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      You may download my PBI file from here.

      Hope this helps.