Introduction This week we are going to focus on data security and how we can ensure that only certain users see certain opportunity data! Sharing inheritance and security predicates are supported in CRM Analytics – this week we are going to look at security predicates – row-level security which enables you to model many different …
Introduction Welcome back to Workout Wednesday! We’re taking inspiration once again from our friends at Makeover Monday. This one is fun – the Makeover Monday team was inspired by a bar chart featured in a blog post and they decided to recreate it in Tableau! You can read Andy’s full post on his blog if you want more info. Today …
2023 Week 19 | Power BI: Formatted bar chart and bookmark navigator Read More
Introduction This week’s challenge is a little SVG fun. Recent Power BI Desktop changes have allowed even further width and height adjustments for images in matrix visuals. So we will be extending this by making a bar chart of chocolate bars. Requirements Power Query Obtain the dataset from 2023-week-11 challenge or; Obtain the dataset from …
Introduction A jittered bar chart has been on my list to do as a challenge since we started this challenge; this week it’s finally time and I can actually leverage the work Lorna Brown has done for the Tableau WoW earlier this year. I ran into different constraints here so I created a new data …
Introduction One of my favorite challenges from the past is from Week 4 2020: Can you combine relative and custom dates? I was always fielding questions if I could have a relative date filter and a date picker on the same dashboard, but hadn’t ever figured it out. After Sean’s challenge that week, I implemented …
#WOW2023 Week 18: Can you combine relative and custom date filters? Read More
Introduction This week we’re going to be building a recipe to create a dataset that we’ll use in a future dashboard. The focus is on IT tickets. We have a data set with information about open & closed tickets and some SLA data. We’re going to be combining these together in CRMA. Before we do …
Introduction This week’s challenge is provided by Guest Contributor Ben Ferry aka Power BI Guy. Requirements Power Query Transform data (hint unpivot and reduce the number of columns) Load Data Power BI Desktop Create a Measure for the Sum of the values column Create a measure to rank the characters based on the measure you …
2023 Week 17 | Power BI: Peaches’ Parameters and Bowser’s Bookmarks Read More
Introduction For the last week of Community Month, I’m thrilled to introduce you to my colleague at Biztory, Nik Eveleigh (@MrEvilEye). I’ve known Nik virtually through our shared love of #WOW for around 3 years. After he returned to the UK from South Africa at the end of last year, I was delighted to learn …
Introduction The April 2023 release of Power BI Desktop gave us dynamic format strings for measures. While the end result could be previously accomplished by using calculation groups, we can now have measures with different formats based upon various conditions – no need to go into Tabular Editor to do this now! While we can …
2023 Week 16 | Power BI: Measure Format Strings and Conditionally Formatted Titles Read More
This week’s challenge is to enhance a Superstore text table, inspired by Luke Stanke’s 26 Ways to Enhance your Tables in Tableau and Sam Parsons’s amazing Super Advanced Tableau Tables.
