topic Re: Slicer to change the value unit in cr lakh thousand etc as per DAX query in DAX Commands and Tips

Slicer to change the value unit in cr lakh thousand etc as per DAX query

Nildatt_Jadhav — Fri, 25 Jul 2025 10:29:06 GMT

Amount_Unit =

SWITCH(TRUE(),

SELECTEDVALUE('Unit Table'[Unit])="Crore",'Segmentation RX 1'[Max]/10^7,

SELECTEDVALUE('Unit Table'[Unit])="Lakh",'Segmentation RX 1'[Max]/10^5,

SELECTEDVALUE('Unit Table'[Unit])="Thousand",'Segmentation RX 1'[Max]/10^3,

SELECTEDVALUE('Unit Table'[Unit])="Base",'Segmentation RX 1'[Max])

Re: Slicer to change the value unit in cr lakh thousand etc as per DAX query

V-yubandi-msft — Fri, 25 Jul 2025 12:58:59 GMT

Hi Nildatt_Jadhav ,

Thanks for posting your query in the Microsoft Fabric Community. I have reviewed your scenario and set up the unit conversion using a disconnected slicer along with a DAX measure. When you use the Unit Table slicer (Base / Thousand / Lakh / Crore), the Amount_Scaled measure updates accordingly to display the correct values.

FYI:

For additional details, please refer to the attached PBIX file. Feel free to reach out if any future adjustments are needed.

Regards,
Yugandhar.

Re: Slicer to change the value unit in cr lakh thousand etc as per DAX query

V-yubandi-msft — Tue, 29 Jul 2025 04:14:51 GMT

Hi Nildatt_Jadhav ,

Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.

Re: Slicer to change the value unit in cr lakh thousand etc as per DAX query

Nildatt_Jadhav — Tue, 29 Jul 2025 10:36:51 GMT

thanks Yugandhar.

One more thing how i can able to apply the same for multiple column value through single slicer setting. example - value in different column such as Sell value, max value, Year till date, etc.

Re: Slicer to change the value unit in cr lakh thousand etc as per DAX query

V-yubandi-msft — Thu, 31 Jul 2025 06:18:33 GMT

Hi Nildatt_Jadhav ,

If you want to keep columns like Sell Value, Max Value, and YTD Value separate but scale them all at once with a single slicer, it's best to create separate DAX measures for each column using the same scaling logic. This way, your layout stays the same and the slicer applies the scaling to each measure consistently.

If you prefer to display these values dynamically like switching between Sell, Max, and YTD in one chart or filtering by metric you can unpivot the columns in Power Query. This will turn them into a single Metric Type column and a related Value column, both controlled by a slicer.

Thank You.