Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
anna-smith27
Regular Visitor

Power BI Questions

Hi everyone, my name is Anna and I've delivered a few of the Power BI Dashboard in a Day for Women, by Women training courses in the United Kingdom. I really enjoy delivering these training days and I think they offer a valuable space for women to learn from and support each other. If anyone has any Power BI related questions do put them below and we can all try to help each other out! 

 

Many thanks,

Anna 

5 REPLIES 5
clairemh
New Member

Hi Anna, how are you? Thank you for creating this forum for ladies.  Is it convenient if I request for feedback for my Power BI project? I am taking part in a competition. I had condensed the findings into a one-page executive summary on Power BI.  Please advise. 

Hi Claire,

 

I'm well thanks, how are you?  If the data is all publicly available and safe to share then feel free to do so. If there are any specific parts that you'd like feedback on then let us know. 

 

Many thanks,

Anna

Thanks a lot Anna. I welcome constructive feedback. If you visit my portfolio page: please check out the Power BI report I did. https://mavenanalytics.io/project/12930  Actually I do not know how to create a nice background for the Canvas in Power BI.  Do you know where I can learn to do this? Your guidance will be very much appreciated. 

hoba1981
New Member

thank you so much for this amazing thread. I have a question, how can I add a code on Power BI to change the "K" for thousand to "M" and the "M" for million to "MM".

 

Thanks,

Hi there,

 

Depending on what your intended purpose is, adding a new measure with a stated variable could work, here's an example of one that worked for me:

 

Formatted Number =
VAR OriginalNumber = [YourNumberColumn] 
RETURN
IF(
    OriginalNumber >= 1000000,
    FORMAT(OriginalNumber / 1000000, "#,##0.0") & "MM",
    IF(
        OriginalNumber >= 1000,
        FORMAT(OriginalNumber / 1000, "#,##0.0") & "M",
        FORMAT(OriginalNumber, "#,##0.0")
    )
)
 
Hope that helps! 
 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.