mattrudy / powerbi-themetemplates Goto Github PK

View Code? Open in Web Editor NEW

191.0 15.0 71.0 241 KB

JSON Templates for assembling Power BI Themes

License: The Unlicense

powerbi powerbi-visuals hacktoberfest hacktoberfest2021

powerbi-themetemplates's Introduction

Power BI Theme Templates

Snippets for assembling Power BI Themes

Get them here or view the visual list below

Are you working with Themes in Power BI but confused about the visual formatting options (visualStyles)?
Have you struggled while trying to make sense of the Power BI report themes documentation?
Do you like JSON?
Do you like sample code?
Do you like other people doing most of the labor for you?

If you answered "Yes" to any of the questions above, this repo is for YOU!

Changing colors in Power BI themes is fairly straightforward. For formatting, the wildcard(*) to make universal changes is convenient. If you want to go deeper into individual visual properties, however, it can quickly get confusing. With these sample templates, explore the individual properties available to each visual (as well as shapes and images). Combine the per-visual templates as needed, alter the values to correspond to your own needs, and build your own Power BI theme.

The purpose of this repository is to provide detail-level reference for each native visual in its own separate file. Look at the format options for a visual in Power BI Desktop and compare to the JSON options side by side. Copy and paste what you need from each visual's JSON to assemble a master Theme file.

Please note that the values in these sample files will appear ugly. Many values are not Power BI's defaults. As soon as something worked, I moved on to the next property. Please modify or remove properties in your own theme file to be what you desire.

Global Level Template 🌎

Adjust titles, backgrounds, report page tooltips, wallpaper, and more for some or all visuals on a page or all pages.

Global Level

Available Visuals 📊

How do you find theme properties? 🔍

It's possible to explore a Power BI Desktop file on your local computer to see the properties that are set, even if they aren't documented by Microsoft yet. Check out this great article for a guide on how to extract these properties.

About this repository: ❔

For questions not answered here, you can View the FAQ.
If you have a question or find an issue, you can Create a new issue.

Areas considered "In-Scope" for this repository: ✅

one global-level theme template to help understand global-level settings.
one template per available visual, covering all default Power BI visuals as well as many custom visuals, to help understand visual-level settings.

Areas considered "Out-of-Scope" for this repository: 🚫

pre-built color themes (You can find these in Microsoft's official themes gallery)
Theme samples to solve specific problems such as adding outlines or hiding visual headers on every visual (You can find these samples in mattrudy/PowerBIThemeSolutions)
JSON file generator for anyone who doesn't want to write their own JSON file (You can use the JSON Generator from PowerBI.Tips)

CI/CD and Automation 🤖

There are several helpful levels of automation that help this project stay valid over time.

When someone new adds an Issue or Pull Request to the project:

Link to Action	Description
	They are greeted, thanked, and pointed to helpful links

When a template or file is added/edited:

Link to Action	Description
	Any hyperlinks are tested to make sure they are valid
	Any JSON files are scanned to make sure they are valid

Every 12 hours:

Link to Action	Description
	Microsoft's blog feed is scanned to check for a new Power BI Monthly Update, and if there is an issue is created to check for new visuals or properties.

Once a week:

Link to Action	Description
	All hyperlinks on all pages are checked to make sure no links have broken

Contributors 👩‍🔬

This project is only possible thanks to the contributions of the community - below is a small set of the people who have made this possible! We're also very thankful to everyone who's written blog posts with useful samples, created issues, or suggested enhancements to this repository, or helped spread the word about this resource! Want to see your name in this list? Check out the 'How Can I Contribute' section in the Contribution Guidelines to get started!

Contribution list made with contrib.rocks.

powerbi-themetemplates's People

Contributors

Stargazers

Watchers

Forkers

mauchy81 quaiadex luisoliveira-w naitrisc jonmccon talchemist udaykapur dududuzhang powerbi-tips davidvalv amdanone gazimbeisaac cissydata colinpeacock1 rpollockahp nklammer mfombad hkhuong davids-bdo codetricksters iourichadour katerinayarusova luciesperkova zahidsqldba07 mores tedcstack nadiafank ouzelthebird avatorl jonmoon74 jabirkangarli christomurray prudvinandan liubovkyry sheymaxi hungling1211 stephc123 ralle8370 pugliathomas caruso1058 troelslp ndh150 nickcodesdotnet mikecarlo thaleti fgardete vitorpcr gitmiguelribeiro alfredleira admachiano ryanpch dmitryvalentinovich s-xema thebagaming andregritgroup adrianmanresa carolkuang fededipa91 janstrauss1 tobiolad joyce0225 marcussyliu rgarciaseija sekailily data-join soyjesusguillen luckyejenavisalomi fdezanet

powerbi-themetemplates's Issues

Shape Map needs 'General' properties section

Source: Cloned from Issue 55 in original repository.

Shape Map needs 'General' properties section

Filled Map - Data Colors

Source: Cloned from Issue 6 in original repository.

Research options under Data Colors for Filled Map

Segoe UI Bold font family does not work [Resolved]

I was trying to set the column headers in a table as Segoe UI Bold. Surprisingly, everything Segoe works, except for Segoe UI Bold. It turns out, if you want to set Segoe UI Bold, you have to use the font family as following:

"fontFamily": "wf_segoe-ui_bold"

Map is missing 'General' properties section

Source: Cloned from Issue 45 in original repository.

Map is missing 'General' properties section

Add JSON Testing Action for all PRs

It's straightforward to compare JSONs to a sample schema and ensure they meet a minimum standard of a test schema.

A valid, but manual version of this as a github action is implemented in https://github.com/MattRudy/PowerBIThemeSolutions

I've reached out to @nhalstead about the action below to understand if his method can handle wildcards as this would be a big QOL improvement for this repo.
https://github.com/nhalstead/validate-json-action

Multi-visual template not working as expected

Source: Cloned from Issue 32 in original repository.

I am trying to merge Slicer, text box and shape codes together but only first code works and other two does not make any changes when I apply them. Also I get a message of success every time I apply. Can anyone help what I missing here

Key Influencers visual needs to be added

Source: Cloned from Issue 58 in original repository.

visualType: "keyDriversVisual"

Lock Master Branch from Commits without PRs

This is disabled for most users but Admins can still do this. All commits should be made in branches and require a PR for traceability.

Need to investigate Smart Narrative visual for options to include in template.

Source: Cloned from Issue 51 in original repository.

Smart Narrative visuals are an extension of the Textbox visual type, and further research is needed to see how they will integrate with themes.

Add Global Color Formatting to Global Template

Global colors can be set in 3 ways:

Data Colors - the color palette that will be available and used by default for all visuals

Other Theme Colors - the colors that will be used to express data states across your reports, including:

good
neutral
bad
maximum
center
minimum
null

Structural Colors - the colors that will affect all other visual elements like labels, gridlines, outlines, backgrounds, etc., including:

firstLevelElements
secondLevelElements
thirdLevelElements
fourthLevelElements
background
secondaryBackground
tableAccent

More reading can be done here:
Data Colors and Theme Colors: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes#setting-theme-colors
Structural Colors: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes#setting-structural-colors

Textbox is missing 'General' properties section

Source: Cloned from Issue 50 in original repository.

Textbox is missing 'General' properties section

Button visual needs 'General' properties section and most others

Source: Cloned from Issue 62 in original repository.

Button visual needs 'General' properties section and most others

Card is missing 'General' properties section

Source: Cloned from Issue 48 in original repository.

Card is missing 'General' properties section

Funnel Chart is missing 'General' properties section

Source: Cloned from Issue 41 in original repository.

Funnel Chart is missing 'General' properties section

set KPI goal text color with JSON theme

Source: Cloned from Issue 33 in original repository.

I am trying to set the font color for the text in the Goals section of the KPI visual.

I am struggling because I can;'t figure out how the property is called: I tried fontColor, color, labelColor to no avail.
Is it documented anywhere?

Thanks

Legend - Circle default icon

Source: Cloned from Issue 2 in original repository.

Find this value

Slicer - Enable Search

Source: Cloned from Issue 5 in original repository.

Determine if there is a way to automatically enable Search in the Slicer

Add Primary Font Classes to Global Template

There are 4 primary level text classes that control fonts used throughout almost every visual (edge cases still exist). These should be added to the global-level template.

More reading can be done here: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes#setting-formatted-text-defaults

Pivot Table is missing 'General' properties section

Source: Cloned from Issue 53 in original repository.

Pivot Table is missing 'General' properties section

Decomposition Tree needs 'General' properties section

Source: Cloned from Issue 59 in original repository.

Decomposition Tree needs 'General' properties section

KPI Visual needs 'General' properties section

Source: Cloned from Issue 57 in original repository.

KPI Visual needs 'General' properties section

New set of Shapes need to be tested with current Shape Theme

Source: Cloned from Issue 63 in original repository.

Current Shape Theme visualStyle is 'basicShape', other visualStyle values seen include 'shape'

Follow-up from jujiro:
I played around with Shape JSON. It worked only when I renamed "basicShape" to "shape". I also noticed that the shape JSON was unable to set the line thickness (weight) and the color. Since the line weight is adjusted in the outline section, perhaps a new section needs to be added to this JSON. I tried various names, to no avail.

dropShadow won't be applied in power bi service

Source: Cloned from Issue 31 in original repository.

Hi. I have tried this json and a custom one over different reports and workspaces. The thing is that the shadow of the visualizations only change in power bi desktop. After you publish them to Service, the reports won't have any shadow at all. Do you know something about it?

Various TRUE/FALSE options in the Visual Header

Source: Cloned from Issue 37 in original repository.

Have you discovered a way to set these by default?

Pie Chart is missing 'General' properties section

Source: Cloned from Issue 42 in original repository.

Pie Chart is missing 'General' properties section

KPI - kpiFormat

Source: Cloned from Issue 1 in original repository.

kpiFormat is mentioned under Indicator in documentation but option does not appear in UI

Stacked Column - Title Color

In the valueAxis section of the Stacked Column visual, the "color" property should be changed to "titleColor".

As an aside: thank you for creating a fork of this repository! You're the best.

Slicers - Missing theme setting for search box background

Source: Cloned from Issue 18 created by @aaronsteers in the original repository.

Part 1
I'm not sure if this is a missing setting or missing configurability on the Power BI product side.

Currently, the background color for a slicer search box is always "white" (#ffffff) and the search box text color appears to be pulled from the top-level theme "foreground" setting - which for a dark mode is likely also "white". The result is a white-on-white search box that isn't readable - and worse, if typed in by the user creates an invisible filter against the slicer's context.

The only workaround I have found is to completely disable search boxes in slicers and then hope the user does not re-enable them. This is especially painful for "dark mode" themes (my use case) but it may be affecting others as well.

Any assist or workaround would be greatly appreciated. Thanks!

Part 3
Temporary workaround is to use a non-white color (blue in the below example) for the "label" text class.

Example:

{
 "name": "sample theme snippet",
  "textClasses": {
    "label": {
      "fontSize": 12,
      "fontFace": "Segoe UI",
      "color": "#c2d8fe"
    }
  }
}

Part 4
Update: When setting the "label" text class, this also overrides the default text box color - which also appears to not be independently configurable. It would therefor be helpful to know if there's also a way to override the default font color for text boxes. (The repo here shows a sample to override the background color but not the default text color for text boxes.)

layout power bi report server web

Source: Cloned from Issue 29 in original repository.

hi
how change layout power bi report server web?

Settings for visual header

Source: Cloned from Issue 21 in original repository.

Hello,
thank you so much for this example repository. It is so much better, than the official Microsoft documentation and saved me a lot of frustration.

The only thing I could not find in here were the granular settings for the visual header, so I analyzed the Power BI Service and found these settings. Maybe you can add them somewhere around here?
This is what I found out (see below). I did use the "background" part, as well as the "showFilterRestatementButton", which is basically the Filter Icon. I also used "showDrillToggleButton", which is the icon that enables drill down on double click. I hope it will help others.

"visualHeader": [
      {
          "show": true,
          "background": {
              "solid": {
                  "color": "#0081C7"
              }
          },
          "foreground": {
              "solid": {
                  "color": "#558100"
              }
          },
          "transparency": 50,
          "showCommentButton": true,
          "showCopyVisualImageButton": true,
          "showDrillDownExpandButton": true,
          "showDrillDownLevelButton": true,
          "showDrillRoleSelector": true,
          "showDrillToggleButton": true,
          "showDrillUpButton": true,
          "showFilterRestatementButton": true,
          "showFocusModeButton": true,
          "showOptionsMenu": true,
          "showPersonalizeVisualButton": true,
          "showPinButton": true,
          "showSeeDataLayoutToggleButton": true,
          "showVisualErrorButton": true,
          "showVisualHeaderTooltip": false,
          "showVisualInformationButton": true,
          "showVisualWarningButton": true
      }
  ]

Donut Chart is missing 'General' properties section

Source: Cloned from Issue 43 in original repository.

Donut Chart is missing 'General' properties section

Include Theme Color Palette

Source: Modified from Issue 22 in original repository.

Would be great to be able to change the default colors that appear on the Power BI desktop color palette selection.

Response by @glitteryqueen:

You can easily do that either by entering the Theme section on your Power BI or with a JSON like:

{ 
    "name": "newcolors, 
    "dataColors": ["#74b9ff", "#0984e3", "#fd79a8", "#fab1a0", "#fdcb6e", "#d63031", "#2d3436", "#55efc4"],
    "background":"#FFFFFF",
    "foreground": "#747480",
    "tableAccent": "#FFFFFF"
}

You just set up 8 different colors for your data set, and the background, foreground and table accent.