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

[Nildatt_Jadhav]

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])

[Nildatt_Jadhav]

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.

[V-yubandi-msft]

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.

[V-yubandi-msft]

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.

[V-yubandi-msft · Accepted solution]

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.