Forum Discussion
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 ...
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.
| Criteria | Lower Limit | Upper Limit |
| 0 - 10 | 0 | 10 |
| 10-20 | 10 | 20 |
| 20-50 | 20 | 50 |
| 50-100 | 50 | 100 |
Thanks,
Akhil.
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 🙂