topic Re: undefined in DAX Commands and Tips

undefined

Korekar27 — Mon, 08 May 2023 15:02:27 GMT

I have all the sales values in Crore.

And I want to create in slicer there would one option values in Crore and another option values in million.When i choose values in Crore all the values is visualization should come in crore and when I choose million all the values in visualization should come in million

How can I convert crore values in million?

Re: undefined

Ajendra — Mon, 08 May 2023 18:48:07 GMT

Hey,

Try this..

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

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.
Create a new slicer visual and add it to the report page.
Add two options to the slicer for Crore and Million.
Select the Sales measure and the Sales in Million measure in the Fields pane.
Go to the Format pane for the Sales in Million measure, expand the Data Label section, and change the Display Unit to "Millions".
Use the Selection Controls option in the Format pane to set the slicer to control the Sales measure and the Sales in Million measure.
Create a visual that shows the sales data, such as a table or a chart.
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.

Re: undefined

Anonymous — Thu, 11 May 2023 06:58:44 GMT

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.

Re: undefined

Korekar27 — Thu, 11 May 2023 15:23:18 GMT

Thankyou for the help.

Re: undefined

Korekar27 — Thu, 11 May 2023 15:23:46 GMT

Thankyou for your help.

Re: undefined

Korekar27 — Mon, 15 May 2023 15:10:34 GMT

Hey bro I've another question

Kindly help me with it

PFAtwo datasets for your reference.

PFB Scenario Objectives:

1) Load the Superstore data to calculate no. of orders that have been generated for the last 6 , 12 , 18 months based on a filter selection.

2) Load the BusinessE2E data to perform the below activities:

Create an optimized data model
Create dynamic YTD , MTD , QTD calculations based on user selection
Calculate top and bottom n analysis for products based on sales and quantity based on user selection
Allow users to dynamically change measures in the chart. Calculate sales, quantity and COGS for this.

Re: undefined

Korekar27 — Mon, 15 May 2023 15:29:24 GMT

Hey bro can you help me with it

PFA two datasets for your reference.

PFB Scenario Objectives:

1) Load the Superstore data to calculate no. of orders that have been generated for the last 6 , 12 , 18 months based on a filter selection.

2) Load the BusinessE2E data to perform the below activities:

Create an optimized data model
Create dynamic YTD , MTD , QTD calculations based on user selection
Calculate top and bottom n analysis for products based on sales and quantity based on user selection
Allow users to dynamically change measures in the chart. Calculate sales, quantity and COGS for this.