So for instance, here’s an existing “normal” measure from my model: So whatever “normal” values we have in our model, we can use those to represent the Visitor (aka the Left-Side Entity). In the previous image, you’ll notice that from DimSchedCurrentWeek “owns” the default relationship to the FactPass table. OK… Pairs of Measures: One “Normal,” One with USERELATIONSHIP OK, and to make things SUPER clear, here’s how it all ties together…ġ) column is used to populate the slicerĢ) When a slicer selection is made, by default that filters the FactPass table to the QB.ģ) But if the inactive relationship is activated instead, FactPass will get filtered by the column. My Slicer Table Has Two Relationships to my Data (Fact) Table: One Inactive by Default What you DO need to know, however, is how it relates to my data/fact table… I am not going to get into how I constructed this table, or how it updates each week, because it’s too specific to my particular data sources to be terribly helpful. So I can get away with a single table… with a twist.ĭimSchedCurrentWeek: This is My “All in One” Slicer Table I want them to see which QB’s are going head to head THIS week! In my case though, I don’t want to let the report user arbitrarily select two different QB’s. And then the user is free to compare ANY two entities of their choosing.Īnd that would require two separate tables – one to populate each slicer – otherwise your selection on one will drive the other slicer to match, and you’ll always be comparing a single entity to itself. In MOST cases, I think you’d put two slicers on the report – one for the left entity and one for the right. So I’m kinda thrilled to be learning the same sort of “knack” in another, highly-capable environment.įor years, I’ve been seeing infographics like these in the sports world, and since I’ve been working on a sports-themed Power BI project, I thought I’d give it a shot:Ī Collection of “Tale of the Tape” Infographics From the Sports WorldĪnd obviously, we need the left side bar chart to display “right to left” rather than the default left to right direction. Besides, hacking the Excel environment and “inventing” new things was always one of my favorite things about Excel in the first place. I gladly accept that risk! While the rest of my company LONG ago moved 100% into the Power BI environment, I still clung to Excel, muttering things like “cold dead fingers.” But this recent project has given me a REASON to embrace the Power BI report canvas. And hey, that’s usually a good thing to share! Keeps others from burning needless time, pushes the envelope a bit, inspires “riffs” and improvements on the core idea, etc.īut there is ALSO the risk that there was a much easier way to do this, in which case I will end up feeling a little bit silly when the avalanche of comments come in starting with the phrase “why didn’t you just…” This is one of those things where I spent a lot of time figuring out how to do something non-obvious. (Used here for football QB’s, but perhaps useful in other “head to head” comparisons – products, ad campaigns, etc.) Setting the Stage: a “Risk” The Desired End Result: Compare Two Entities in a Specific Visual Style
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |