Actual Tips of the Week
BLOG Post: The ultimate Power BI JSON Theme
Links der unterschiedlichen Kategorien werden aktuell überarbeitet. Da die Links über LinkedIN nicht mehr erreichbar sind gibt es nun ein Git Repository dafür: https://github.com/K-Borchert/Power-BI-Tips-of-the-Day/blob/main/README.md
________
Links of the different categories are currently being revised. Since the links are no longer accessible via LinkedIN, there is now a Git repository for them: https://github.com/K-Borchert/Power-BI-Tips-of-the-Day/blob/main/README.md
- BLOG Post: 5 Tips how to help your Users (Power BI Service)
- Activate Power BI Service App in Teams (global setting)
- BLOG Post: Power App & Power BI
- Report Design with IBCS
- BLOG Post: AdhocSubscriptions – Power Platform
- BLOG Post: Export Reports from Pesonal Workspaces with PowerShell
- Appsource – Microsoft Marketplace (Templates, Apps, Services)
- Power BI Community – Find some sample Reports
- Power BI Templates in the Power BI Service
Under construction (Revision)
- Column description in Power BI Desktop
- Character Map for blank titel in Visuals
- Create a mobile view in Power BI Desktop
- Hide Tabels/Columns (Data modeling Tip)
- Activate Preview Features in Power BI Desktop
- Relative Date slicer
- Data modeling tabs for different views
- Search bar in Filter visual
- Grouping Visuals in Power BI
- Unpin and pin Visuals to your Visualisation pane
- New Navigation Pane in Power BI (11/2021)
- What is a pbit?
- What is a pbids?
- Copy Folder from one to another table (only Folder without content)
- Create subfolder in a Measure Table
- KPI storage (Table for Measures)
- Top N Filter
- Filter reset button
- Show columns as rows (Matrix Visual)
- Conditional formatting with percentages (Matrix/Table Visual)
- Change page view in Power BI Desktop
- URLs on column values (Matrix/ Table Visual)
- Disable tooltip in Matrix/ Table headers (Visual)
- Edit Interactions
Under construction (Revision)
- FORMAT function
- Shortcut: Zoom in and Out into function field
- Shortcut: Change same values in DAX with one shortcut
- BLOG Post: Mark dynamic average in Bar chart Example: LinkedIN
- BLOG Post: Filter design with Bookmarks Example on LinkedIN
- Create a Heatmap from Matrix Visual – External Blog Post (from James Andrew)
- Change colors in Visuals with DAX measures (Field/Rules)
- Change header name/color with a slicer selection
- Date range slicer (with calculation groups)
- Date range buttons
- Making Visual colours transparent
- Dynamic page navigation with buttons
- Unify the column spacing (Matrix Visual)
- KPI storage 2 (another way to create a measure table)
- “Last date” as name in slicer (Use names in Dates)
- Field value: conditional formatting with Power BI basic icons
- “No Sales” instead of BLANK values -with DAX function COALESCE (recommended for Card Visuals!)
- Extract values in a column
- Index Columns for Data modeling
- Column profiling in Power Query
- Comments in Power Query
- Copy one Tabel from Power Query into another one
- BLOG Post: Changing Headings in Power Query Example: LinkedIN
- All Power Query function in one Query
- Use tables from the Internet with the Web Connector
- BLOG Parameterization of data sources Example on LinkedIN
- BLOG Post: Use SSRS without SQL knowledge LinkedIN Example
Under construction (Revision)
- Help button in Visuals
- Decomposition Tree Visual
- Use Windows Icons (Icons instead of Column header)
- Automatic resize of columns in a Matrix Visual
- Change Year/Month order in Matrix Visual
- Blank column line in Matrix Visual
- Copy table from Matrix Visual with Drill Down
- Customized font in JSON Theme
- Make your JSON code readable (jsonbeautifier)
- JSON – Theme Generator (Create Themes for Reports with a few clicks)
- Collaps/ Expand all at once- Matrix Visual
- Custom Visual: Zebra BI – IBCS certified Visuals
- Custom Visual: Inforiver (Excel-feeling in Power BI)
- Visualization Best practices: Using Bar Charts – Colors
- How to format dates for date slicer “between”
- Visualization Best practices: Using Bar Charts – Axis
- Tooltip in only one Column in Matrix Visual (work around)
- Show values with no Data in Visuals by default
- Expand/Collaps Matrix Visual with one Click
- BLOG Post: Custom pictures as filter
- Copy data from Matrix Visual into Excel
- Teams activitiy Report from Power BI
- Inner paddding in Bar Charts
- Map Visual in Power BI
- Power BI Report live in Power Point presentation (NEW)
- BLOG Post: Filter and Smart Narrative Visual Example on LinkedIN
- Use Min and Max in your Conditional Formatting
- Conditional formatting – Hex and Name as colors
- More external Links about Conditional formatting – Hex and Name as colors:
- Basic Icons from Power BI for Measures
- 150 color names for Power BI to use
- More color names for Power BI to use
More Tips:
- Traffic Light and loading bar Visual
- Filter buttons with basic slicer Visual
- Drill Through with a button
- Simple Bookmarks
- Tooltips
- Implement background picture into JSON Theme
- Custom Icons in conditional formatting (Matrix/ Table Visual)
- Customise series in Bar & Line Chart
- Change text size with one setting (Matrix/ Table Visual) – old Navigation Pane!
- Dynamic values in Textbox Visual
- Power Point Backgrounds for Power BI
- External: Custom format strings in the format box (Tip from Parvinder Chana)
- Storage in Power BI Service
- Exportable formatted Data tables
- Use Bookmarks in Power BI Service to create your own overview start page
- Embedding Reports into SharePoint
- Table preview from Dataset in Power BI Service
- Create a Power BI Dashboard (Power BI Service feature only!)
- Featured Tables in Power BI Service – User Tables from Datasets in Excel too!
- Messages in Power BI Desktop before publishing Reports
- Help your Users to find help with the Get Help feature in Power BI Service
- Make your Content more visible with featured content setting in Power BI Service
- Branding in Power BI Service Portal
- Report Templates in Power BI Service
Power Platform – Learning Advent Calendar 2021
- 1) Power BI Guy – https://www.youtube.com/c/powerbiguy (All about Power BI – from Starter to Expert)
- 2) Kratos – https://www.youtube.com/c/ChrisWagnerDataGod (Power BI God Maker)
- 3) Stephan –https://www.linkedin.com/in/%C5%A1t%C4%9Bp%C3%A1n-re%C5%A1l-464084152/ (Creator of Power BI Cheat Sheet)
- 4) Artur – https://www.linkedin.com/in/datakoenigartur(All about Power BI – German Channel)
- 5) Nikola – https://www.youtube.com/c/DataMozart (All about Power BI – more Advanced Stuff)
- 6) SQLBI (Marco & Alberto) – https://www.youtube.com/c/SQLBI (Power BI – DAX for everyone)
- 7) Isabelle – https://thesqlgrrrl.wordpress.com/ (Power BI – Adoption)
- 8) Nicky – https://www.nickyvv.com/p/about.html (All about Power BI – more Advanced Stuff)
- 9) Marc – https://data-marc.com/ (All about Power BI – more Advanced Stuff)
- 10) Guy in the Cube (Adam & Patrick) – https://www.youtube.com/c/GuyinaCube (Power BI Institution – Yoooooo what’s up 😉 )
- 11) Marcus – https://www.thinkbi.de/ueber/ (All about Power BI – German Channel)
- 12) Curbal (Ruth) – https://www.youtube.com/c/CurbalEN (Power BI in all colors – DAX, Power Query,…)
- 13) May – https://www.youtube.com/c/Agent008 (All about Power Apps and more!)
- 14) Jonny – https://www.youtube.com/c/GreyskullAnalytics (All about Power BI – from Starter to Expert)
- 15) MS Power Platform Germany – https://www.youtube.com/c/MSPowerPlatformDE (All about Power BI – German Channel)
- 16) Just – https://www.youtube.com/c/justBlindbaek (Power BI Quizzes)
- 17) Reid – https://www.youtube.com/c/HavensConsulting (All about Visualizations in Power BI)
- 18) TechStyler – https://www.youtube.com/channel/UCm8FTGFNTXWf9wxow16KDNQ (get inspired by wonderful people)
- 19) BI Elite – https://www.youtube.com/c/BIElite ( All about Power BI – for Advanced)
- 20) Avi – https://www.youtube.com/user/ModernExcel (All about Power BI – form Starter to Expert)
- 21) MS Power BI – https://www.youtube.com/user/mspowerbi (Official Youtube Channel)
- 22) RDACAD – https://www.youtube.com/c/Radacad (All about Power BI – from Starter to Expert)
- 23) Lars – https://www.youtube.com/user/Larsch381 (Power BI in German and English)
- 24) Rishi – https://www.learndatainsights.com/power-bi-quiz-da-100/ (Quiz to prepare for Exam DA 100)