undefined

Hey,

Try this..

To create a slicer with options to view values in Crore and Million in Power BI, you can follow these steps:

1. Create a new measure to convert the sales values from Crore to Million. You can use the following formula:

   Sales in Million = [Sales] / 10

   This formula divides the sales value by 10 to convert it from Crore to Million.

2. Create a new slicer visual and add it to the report page.

3. Add two options to the slicer for Crore and Million.

4. Select the Sales measure and the Sales in Million measure in the Fields pane.

5. Go to the Format pane for the Sales in Million measure, expand the Data Label section, and change the Display Unit to "Millions".

6. Use the Selection Controls option in the Format pane to set the slicer to control the Sales measure and the Sales in Million measure.

7. Create a visual that shows the sales data, such as a table or a chart.

8. Format the visual to show the appropriate unit based on the slicer selection. You can use the Selection Pane to show or hide visuals based on the slicer selection.

By following these steps, you can create a slicer with options to view values in Crore and Million and also convert the sales values accordingly in your Power BI report.

Hi Korekar27 ,

You could try the custom format to create two another columns. And then create slicer to choose them.

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Million = ROUND([Value]/10000000,2)

Core = ROUND([Value]/100000000,2)

You'll see the two columns are displaying the below format.

Create a field parameter for filtering.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Drag the two columns to the left.

Click "Create", the field parameter with a slicer will be generated.

At last, you can show the different format dynamically.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.