PowerBI – Number and Currency Formatting

October 31, 2017

After looking for a solution why my Number Formatting did not want to work out…

After creating a new Measure it returned the classing US based formatting.

image

While I wanted to have the EU formatting in my table.

Power BI Desktop Client Regional Setting :

Even after changing the Power BI Desktop Client settings, it did not take effect Sad smile

image

Solutions :

Go to Control Panel –> Region –> FORMAT

image

If this format is not in line with your region it will overrule the Power BI Regional settings ?

image

So after applying the correct region format settings on OS level, everything appeared as expected Smile

PS : These figures are just demo based Winking smile

Enjoy!

Advertisements

PowerShell – How to Format Output

January 16, 2015

Sometimes you don’t see the data completely.

Like this :

CLS

if((Get-PSSnapin | Where {$_.Name -eq "Microsoft.SharePoint.PowerShell"}) -eq $null)
{
    Add-PSSnapin Microsoft.SharePoint.PowerShell;
}

Get-SPTimerJob

image

Solutions :

Use some formatting commands.

CLS

if((Get-PSSnapin | Where {$_.Name -eq "Microsoft.SharePoint.PowerShell"}) -eq $null)
{
    Add-PSSnapin Microsoft.SharePoint.PowerShell;
}

$list = Get-SPTimerJob 

foreach ($objItem in $list) {
#- or + is left or right alligned,
# the First Parameter 0-2 is the column index
# Second Parameter is column width
  "{0,-80} {1, 45} {2, 25}" -f `

 $objItem.name, $objItem.Schedule, $objItem.LastRunTime

}

image

Powershell has many more formatting options, have a look at the internet 😉