Forum Discussion
Numeric Between Slicer Not Showing Actual Values
Hi. I created a new column called NetProfit_Filter in Transform Data. The column rounds net profit to the nearest 1,000. When I use the column in a between slicer, the rounded numbers aren't showi...
Hi SHullen,
Hope you are doing well!
Use a DAX Calculated Column Instead
Delete the Power Query column and create it in DAX:
NetProfit_Filter =
MROUND([Net Profit], 1000)
Hope this helps! Feel free to ask more questions if needed. Don't forget to mark as solution andgie kudos if that's works. That's motivate me to keep helping others.
Best regards,
Oussama (Data Consultant - Expert Fabric/Power BI)
Hi Oussama. Thanks for your assistance with this. I created it in DAX but still had the same issue. It's strange. It's only an issue with "between". If I change the slicer to dropdown, the values show correctly. But I need between in this case. I guess I will try the "What If" solution that was suggested.