cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Regular Visitor

My client has given me one PowerPoint Presentation slid and he told me I have to use only those colours which are
available in that slide.
I have used tried to use Customer Color, but I was not getting the same colour which I need.
here is the process from where I the same colour.
below colours, I need to use 
PIC1.png

 Below is the DASHBOARD
PIC 2.png
Now we can resolve this issue if we have HEX colour code.
PIC 3.png

Let's get the HEX colour code.
1)Open image in Paint.
PIC 4.pngStep 2 )Use Color picker and point on the colour which you need you will see in the foreground colour then click on edit color and you will see the RGB color for CODE. 
          
PIC 5.png
Copy RGB code and go to 
https://www.rgbtohex.net/

PIC 7.png
Once you will put the RGB code you will get your HEX Code. and then put this code in power bi Enjoy.

PIC 8.png

Regards

Varun Jain

Super User II
Super User II

Learn the logical processing order of Power BI from Get Data to Report. If you don't understand why a slicer selection doesn't update your calculated column or you're trying to refresh the report to recalculate, this post might help shed some light on how Power BI thinks.ExcelwithAllison.com 

Read more...

Resolver I
Resolver I

Do you feel that your PC sometimes doesn't like your large Power BI models?

Not enough memory? CPU is struggling?

But 90% of the time you are just fine.

So do you really need to spent big $$$ on 32GB laptop with powerful CPU for only those 10% use cases?

Not necessarily - consider using Azure Virtual Machine for your occasional Power BI loads.

I would like to share my own experience.

The bottom line is -  it's easy to setup and you pretty much only pay per hour used.

So I would definetely recommend to give it a try!

Read more...

Microsoft
Microsoft

When adding a Max line in the Analytics pane for the Line chart, the Max line does not disappear when measure returns BLANK. 

Read more...

Community Support
Community Support

The blog is about how to use RANKX() function in three different items.

Read more...

Kudo Kingpin
Kudo Kingpin

Power BI analytics maximizes the business potential of your customer data. Customer analysis may involve your existing customers, your lost customers, as well as your new customers. This type of analysis is crucial for your business growth, as it will be the basis for your business decisions and endeavors.

 

Picture1.png

 

Read more...

Microsoft
Microsoft

In the October 2020 release of Power Bi, a new powerful feature was added: Dynamic Parameter binding.

In this article, we will describe how to unlock the potential of this feature, where it can be used, and its limitations.

Read more...

Regular Visitor

I was looking solution for one of my problems where my requirement was
I have 2 slicers wherein
Slicer (A) I had a Country option like Denmark, Norway, Europe  
Slicer (B) I had Currency Type where the option was Local or USD 
So the actual requirement was when any user will log in from any Country
he/she should see currency which Is related to that
Country only. and USD was the base currency which everyone can see.
I have applied security based on Country but if once person having access
more then one Country then he/she can see in text box currency local name like Denmark -DKK.

 

Today in this blog, I will be showing how one can implement the functionality of how you can resolve this issue.

Here we need to create a Currency table where you can show the currency Type Currency Name and extra details if you want.
I have Took ID and currency type and this will be an independent table.
Table 1.png

 

You see the below relationship where Dim_Currency table is an independent table.

Table 2.png

 

 

In the below screenshot you can see Slicer A and B with textbox what you need to create a measure
for Slicer A -- Selected Currency = SELECTEDVALUE(Dim_Currency[Currency])
for Slicer B --  Selected region = SELECTEDVALUE(Orders[Country_name])

Then Use IF condition and show your value

Selected_Currency & Country =

IF([Selected Currency]="Local" && [Selected region]="EUROPE","EUR",

IF([Selected Currency]="Local" && [Selected region]="DENMARK","DKK",

IF([Selected Currency]="Local" && [Selected region]="FINLAND","EUR",

IF([Selected Currency]="Local" && [Selected region]="NORWAY","NOK","USD"))))

 

Table 3.png

 

 

Regards

Varun Jain

 

Microsoft
Microsoft

Use the UNICHAR function and Unicode to create visuals.

Read more...

Community Support
Community Support

The article provides two ways of substring in Power BI. One is to use DAX, the other is to use Power Query.

Read more...

Helper I
Helper I

It is often useful to get some data available only in PDF files. Those are mainly external reports, published for advertising or informational purposes, widely available on the web. Using Power Query Power BI (or Excel), we can extract tables or entire pages of information from PDF files.

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.