if you select in the Slicer more than one value with Ctrl, for instance you want to add two measures profit and sales , within the y axis will that work? i want to use them as a legend breakdown on a stack bar.
es, you can absolutely use multiple measures selected from a slicer with Ctrl as a legend breakdown on a stacked bar chart. This is a common and effective way to compare different measures within the same visualization. Here's a breakdown of how to achieve this: Create a stacked bar chart: Place your dimension (e.g., category, product, date) on the x-axis and your measure (e.g., sales) on the y-axis. Add a slicer: Create a slicer for the desired measure (e.g., profit, sales). Select multiple values: Use Ctrl to select multiple values from the slicer. Place measure on legend: Drag the measure from the Values shelf to the Legend shelf. This will create a stacked bar chart where each stack represents a value selected from the slicer, and the legend will display the corresponding measures. This allows for easy comparison and analysis of multiple measures within the same visualization.
I am trying to display Sales amount in Cr like 11,22,33,444. This is working fine in power bi desktop but when I publish into power bi service then the value shows like 112,233,444. I want to show same like desktop pattern. Can you please help if possible. Thank you.
Hi Siva Kumar! It sounds like you're encountering formatting differences between Power BI Desktop and the Power BI Service. To display the sales amount in the desired format (like 11,22,33,444) in the Power BI Service, try the following steps: Create a Measure: If you haven't already, create a measure to format the sales amount. For example: DAX Copy code SalesAmountFormatted = FORMAT(SUM(Sales[Amount]), "##,##,##0") Set Formatting in Power BI Desktop: Ensure that you set the formatting for your measure in Power BI Desktop. Click on the measure, go to the "Column tools" or "Measure tools" tab, and set the desired format. Publish Again: After making these changes, republish your report to the Power BI Service. Check Service Formatting Options: In Power BI Service, go to the report, select the visual, and check the formatting options to ensure they match your desired display format. If you still experience issues, let me know, and we can troubleshoot further!
Wonderful job . It is very much helpful. I am also waiting for this types of more video with practice Excel files.
Jeetu
From Bangladesh
Will upload soon
Excellent video mam, Thank you.
Today I understood the real meaning of switch function thank you so much 😊
you are welcome
As always, Very clear explanation 👍
Glad you think so!
Very nice...you always explain nicely 😊
Thanks a lot 😊
Awesome guide!
Thank you so much, Please subscribe our channel for regular updates
Thank you madam, good explanation.
Thank you so much
As always, explanation was on the point Uma.
Can we do this with parameter??
Thank you so much for your comment, please subscribe our channel for regular updates. it motivates us a lot
Can we get this by using field parameters?
yes
Very useful 😍
Glad you think so!, Please subscribe our channel, its motivated us to do more videos
if you select in the Slicer more than one value with Ctrl, for instance you want to add two measures profit and sales , within the y axis will that work? i want to use them as a legend breakdown on a stack bar.
es, you can absolutely use multiple measures selected from a slicer with Ctrl as a legend breakdown on a stacked bar chart. This is a common and effective way to compare different measures within the same visualization.
Here's a breakdown of how to achieve this:
Create a stacked bar chart: Place your dimension (e.g., category, product, date) on the x-axis and your measure (e.g., sales) on the y-axis.
Add a slicer: Create a slicer for the desired measure (e.g., profit, sales).
Select multiple values: Use Ctrl to select multiple values from the slicer.
Place measure on legend: Drag the measure from the Values shelf to the Legend shelf.
This will create a stacked bar chart where each stack represents a value selected from the slicer, and the legend will display the corresponding measures. This allows for easy comparison and analysis of multiple measures within the same visualization.
Please can you make end to end report on audit dashboard
sure, will make it shortly
I am trying to display Sales amount in Cr like 11,22,33,444. This is working fine in power bi desktop but when I publish into power bi service then the value shows like 112,233,444. I want to show same like desktop pattern. Can you please help if possible. Thank you.
Hi Siva Kumar! It sounds like you're encountering formatting differences between Power BI Desktop and the Power BI Service. To display the sales amount in the desired format (like 11,22,33,444) in the Power BI Service, try the following steps:
Create a Measure: If you haven't already, create a measure to format the sales amount. For example:
DAX
Copy code
SalesAmountFormatted = FORMAT(SUM(Sales[Amount]), "##,##,##0")
Set Formatting in Power BI Desktop: Ensure that you set the formatting for your measure in Power BI Desktop. Click on the measure, go to the "Column tools" or "Measure tools" tab, and set the desired format.
Publish Again: After making these changes, republish your report to the Power BI Service.
Check Service Formatting Options: In Power BI Service, go to the report, select the visual, and check the formatting options to ensure they match your desired display format.
If you still experience issues, let me know, and we can troubleshoot further!
We can achieve this one by using Field Parameter right?
Yes
yes
Thank you madam
You’re welcome 😊