PowerBI.tips

Tag: Color Theme Tool

  • Unlock Your Creativity with the Power BI Tips Designer: Exciting New Features!

    Unlock Your Creativity with the Power BI Tips Designer: Exciting New Features!

    At Power BI Tips, we’re committed to providing you with the best tools and resources to enhance your report building experience. That’s why we’re thrilled to announce a range of exciting new features to the Power BI Tips Theme Generator! With these new additions, we’re taking theme customization to a whole new level and empowering you to create consistent, visually stunning reports and dashboards like never before.

    Introducing the Color Wheel:

    We understand that choosing the perfect colors for your visualizations can be a challenging task. That’s why we’ve integrated a brand-new color wheel into the Theme Generator. Now, you can effortlessly explore an extensive range of colors and find the perfect palette that aligns with your brand or design preferences. The Color Wheel feature makes it easy to experiment with different color combinations, ensuring your visualizations are visually striking and impactful.

    Enhanced Gradient Selections:

    Gradients add depth and visual interest to your reports and dashboards. With our enhanced gradient selections, you can now choose from a wide array of gradient styles to create eye-catching visualizations. Whether you prefer subtle transitions or bold color shifts, the Power BI Tips Theme Generator has you covered. Unleash your creativity and elevate your designs with stunning gradient effects.

    Customizable Icons:

    Icons are an essential element of any table or matrix, providing visual cues and enhancing the overall user experience. Now, with the Power BI Tips Theme Generator, you can not only choose from a vast library of icons but also customize their colors to match your theme perfectly. Seamlessly integrate icons into your visualizations and make them more engaging and intuitive for your audience. Build fully customized experiences with over 8,000 icons to choose from.

    Upload and Apply Theme Files:

    We’ve listened to your feedback, and we’re excited to introduce the ability to upload and apply theme files within the Power BI Tips Theme Generator. If you have existing theme files or want to try out themes created by others, simply upload them and see the magic unfold. This feature allows for seamless collaboration, sharing of themes, and easy updates saving you valuable time and effort. Themes are easily uploaded and validated against the new Microsoft specifications. Issues and code bugs are highlighted by row and easily discoverable in the Code Editor.

    Introducing the Code Editor:

    Advanced users and developers are going to be thrilled with the new Code Editor feature. With this powerful tool, you can now dive deep into the code behind your themes and make intricate customizations. This level of control gives you the flexibility to fine-tune every aspect of your theme and create truly unique and tailored designs.

    Unlock the Full Potential with Tips+ Themes Subscription:

    Some of these exciting new features are only available by signing up for the Tips+ Themes subscription. With this subscription, you gain access to the entire suite of advanced features. This includes access to all Customizable Icons, Upload and Verify Theme Files, and the Code Editor. The Themes Generator is designed to supercharge your creativity and streamline your theme creation process. Elevate your reports, captivate your audience, and have confidence that all your reports will look amazing.

    Buy some fun Swag

  • Import Color Theme & Color Theme Generator

    Import Color Theme & Color Theme Generator

    March is an exciting month, and with this release of Power BI we have been given some long asked for features. One such feature is the ability to import a color theme. The color theme defines the starting colors for your visuals. Before the ability to import a theme one would have to first define each color that they want to use in a Power BI report by changing each visual to have the correct color scheme. Color themes are useful when trying to make a dashboard and you want to use colors that resemble a company’s product or logo. Alright, let’s get started and make and add our own color theme to a report.

    Begin by opening up Power BI Desktop. Make sure you have the latest version of Power BI Desktop, you can download the latest version here. The import color theme feature is available in the March 2017 release.

    On the Home ribbon click the Enter Data button.  Enter the following table of data and name the table Data.

      Product    Value
    Item120
    Item225
    Item315
    Item440

    The Create Table should look similar to the following.  Click the Load button to proceed.

    Load Data Table
    Load Data Table

    Power BI will load the data to memory and the Fields pane will reveal our newly created columns. Add the Stacked Column Chart on the report page and appropriate fields shown in the image below.  You will notice that the default colors are automatically overlaid onto our visual when we add the Product to the Legend visual field.

    Add Stacked Column Chart
    Add Stacked Column Chart

    Next, let’s take a peek at the standard colors that are offered by default from Power BI.  Click on the Paint Roller found in the Visualizations pane.  Then expand the data field labeled Data colors.  Under Item1 click the little triangle.  This will expose the current color scheme that is loaded.

    Default Color Scheme
    Default Color Scheme

    Now we will load the new color theme.  But before we can load the color theme we have to generate the color theme first.  The color theme has some requirements.  First the color theme must be written as a JSON file and must adhere to the JSON format.  For developers this will be a very simple google search to accomplish this.  However, I know there are some out there that do not enjoy doing development work.  So, in a PowerBI.Tips first, I have developed a custom tool to make the color theme generation super simple.

    Introducing the PowerBI.Tips Color Theme Generator (CTG) to help Power BI users create quick and easy JSON code files to input into Power BI for the color themes. Not everyone has a coding background, and though there will be tutorials and examples of how to set up the JSON, if you aren’t familiar with the language a small typo could have you spending precious time troubleshooting the issue.

    update 3/15/17: The Advanced Theme Generator has been released.  Find the tool here.

    Click the following link to open up the PowerBI.Tips Color Theme Generator in a different Browser window.  Once the browser loads the Color Theme Generator follow the instructions listed at the top of the page to select your colors.  The only required fields are the Name, and at least one color.  For this tutorial I selected a number of nice pastel colors.  Click the Download Color Theme button to download the JSON file that we will use in Power BI.

    Note: The Generator was tested on Google Chrome.  Also, clicking the Download button will download the JSON file to your browser’s default location.  You will need to know this file location to load the file into Power BI Desktop. 

    PowerBI.Tips Color Theme Generator
    PowerBI.Tips Color Theme Generator

    Head back over to Power BI Desktop.  On the Home ribbon click the button labeled Switch Theme.  Then click Import Theme.

    Import Theme Button
    Import Theme Button

    Note: If you want to remove your custom theme you will click on the Switch Theme, then click on the Default Theme.  The normal power BI colors will be restored.

    Navigate to where your browser downloaded the file.  Select the file labeled PowerBI-Tips Color Theme.  Click Open to load the theme.

    Load Color Theme
    Load Color Theme

    PowerBI will prompt a message letting you know everything loaded correctly. Click Close to see the new theme applied to our visual.

    Theme Load Successful
    Theme Load Successful

    We can now see our custom theme by clicking on the Paint Roller found in the Visualizations pane.  Then expand the data field labeled Data colors.  Under Item1 click the little triangle.

    Tada, now we have a custom color scheme that we create and loaded.  Also, now that we the JSON file you can modify the file and keep it for future projects.

    Loaded Custom Color Theme
    Loaded Custom Color Theme

    Thanks for following along.  If you liked this tutorial please be sure to share.  Also if you want to know more about me you can visit my About page and follow me on twitter or Linkedin for updates.