cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kirthi12 Frequent Visitor
Frequent Visitor

Update new features/ conditional formatting based on category

I am new to power bi and am trying to add a text filter from the store,  and I get an error saying - unable to import the issue, visit the support and report the issue". Been trying for 2 days. Also, the app is installed on my desktop and I get an update notification, leading me to a page to reinstall the software altogether. 

And am using a direct query to import all the data from sql and i can't see conditional formatting. I need to color code categories, how can i work on this?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Update new features/ conditional formatting based on category

Hi there

yes if you import the data into Power BI using the SQL Query, you will then be able to complete the conditional formatting.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
5 REPLIES 5
Super User
Super User

Re: Update new features/ conditional formatting based on category

Hi there

I would suggest that you Import the data from your SQL database. This should then allow for the conditional formatting.

Also there were a few bugs, that is why there is another release for Power BI Desktop.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
Kirthi12 Frequent Visitor
Frequent Visitor

Re: Update new features/ conditional formatting based on category

Hey,

I cannot import data cause it is a 400 lines query with a lot of joins. There are 2 databases with millions of rows being affected. Is there another way? I need to color code categories for the dashboard

 

Super User
Super User

Re: Update new features/ conditional formatting based on category

Hi there

I am not sure that there is another way. Even though it is a few million rows it should fit into the PBIX?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
Kirthi12 Frequent Visitor
Frequent Visitor

Re: Update new features/ conditional formatting based on category

Are you suggesting that i import all the data from the database to power bi and then write a sql query on power bi,

will conditional formatting work then? 

Super User
Super User

Re: Update new features/ conditional formatting based on category

Hi there

yes if you import the data into Power BI using the SQL Query, you will then be able to complete the conditional formatting.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 294 members 3,315 guests
Please welcome our newest community members: