Thanks very much. I can’t remember where I saw that specific feature. Maybe the power release blog powerbi.microsoft.com/en-us/blog/ or someone’s demo somewhere Here’s more info on formatting strings: docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
If I move my measures into folders will it break my existing reports, or will PBI take into account that the measures have moved and automatically adjust things? Also, I can see this possibly being fine within a given open report, but what about other reports that aren't open when the measures are moved? Thanks
It will work fine as long as you didn’t refer to measures using the Table prefix. E.g. TOTALYTD( [Sales], Calendar[Date]) would continue to work fine. But if you wrote =TOTALYTD( SalesTable[Sales], Calendar[Date]) then the formula would need “SalesTable” removed. Other reports will follow same logic as this.
Hi Wyn, how many kinds of format can i type in that box? for example i want my numbers to show in thousands or with pp (percentual points), how can i do that?
Check this out: Use ,, ( double comma) to show in thousands. Put #,0.0 for decimal docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
Sir i have 3 tables with same data structure, the first column contains the country name, the second contains the topics like sales, actual, budget, and the 3rd and 4th with numerical values, what i want is the data to be side by side with the topics to become common for everycolumn and country name to be on as header, how do i achieve in power query.
Tremendous criticism of Power BI's conditional formatting. I loved it. :) Thank you for this great tutorial Wyn!
You’re welcome Iván 😊
Really good. Learnt new things
Great to hear 😀
Great tutorial.
I wonder how you found out that you could insert the formatting in the Format box.
Where can we get other examples?
Thanks
Thanks very much. I can’t remember where I saw that specific feature. Maybe the power release blog powerbi.microsoft.com/en-us/blog/ or someone’s demo somewhere
Here’s more info on formatting strings: docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
If I move my measures into folders will it break my existing reports, or will PBI take into account that the measures have moved and automatically adjust things? Also, I can see this possibly being fine within a given open report, but what about other reports that aren't open when the measures are moved? Thanks
It will work fine as long as you didn’t refer to measures using the Table prefix. E.g. TOTALYTD( [Sales], Calendar[Date]) would continue to work fine. But if you wrote =TOTALYTD( SalesTable[Sales], Calendar[Date]) then the formula would need “SalesTable” removed. Other reports will follow same logic as this.
Hi Wyn, how many kinds of format can i type in that box? for example i want my numbers to show in thousands or with pp (percentual points), how can i do that?
Check this out:
Use ,, ( double comma) to show in thousands.
Put #,0.0 for decimal
docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
@@AccessAnalytic Thank you very much, this is great!
Thes were great. I knew most of them but it’s a great little package. I’ll have to share with my fellow developers.
Thanks Nate
Thank you 🙏
You’re welcome
Wow! Powerful Hacks
Thanks Bhaskar
Great content
Thank you Khaled
owwww
Great... great tips
Cheers Felipe
Thank, love it! Till the next one i hope.
Thank you
Sir i have 3 tables with same data structure, the first column contains the country name, the second contains the topics like sales, actual, budget, and the 3rd and 4th with numerical values, what i want is the data to be side by side with the topics to become common for everycolumn and country name to be on as header, how do i achieve in power query.
Hi, best to post your question here ..techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat
Likely some form of pivoting involved