I’m having a bit of an issue trying to calculate a percentage in my Power BI Model.
I’m not looking for someone to write the DAX for me but to get some insight into anything Sam or someone else has released that could help me. I’ll learn it better if I do it my self rather than copy your DAX.
My issue (no pbix) is this:
I have a Spreadsheet that I can count the rows on to get a total.
I have a second column that has entries for Order, Reorder, Trial and blank entries (blanks are unimportant)
I need to calculate the percent of Order, Reorder and Trial entries and be selectable by a Slicer
I know Sam has done this in the past but my searching is coming up blank.
I know he also deals with this issue in the ALL and ALLSELECTED videos, but start with the two above, and if those don’t solve your issue, this would be the next place to look…
How do I remove the blue edging from my theme. Don’t want the blue overall blue but it looks terrible in the Desktop (Display1) and the Service (Display2
Very difficult to say without a PBIX @GuyJohnson, but if your report uses a Page Background image, I’d cycle through the Image Fit options and see if that helps. Greg
Neither one of the suggestions work. I like the waves in the background and the green color. What’s bugging me is the blue border that I can’t get rid of.
It’s the page wallpaper, @GuyJohnson. I’ve never used wallpaper before this moment (only backgrounds), but after one quick web search, page wallpaper is larger than the page background. I can “eliminate” the border by setting the transparency of the background to 100%, but now everything is all blue. If you remove the image from the wallpaper and just use it in the background instead, then use a full-screen rectangle with your green and 50% transparency, you should be good (I don’t have time to try this out myself right now). Good luck. Greg
You can use PowerPoint as well to create a background you like, with all the overlays and transparencies you like, then export as an image, then use this as your page background … I’ve found this works quite well and use it frequently. Greg
I’ll give that a try early next week, for now I dropped an image of the local plant that I’m referencing at 60% transparency and selected fit and it looks good.
I was just trying to use one of Microsoft’s themes to begin with for a bit of a change from plain colors.
This turns out to be unexpectedly tricky. Here’s how I did it:
I used @Greg’s zip file trick to try to find the image file. That was helpful in that it let me burrow into the directory structure of the file, but no PNGs or JPGs were found.
Turns out they encode the wallpaper file as binary 64 in the JSON theme file. I copied the binary 64 code into an online decoder to turn it back into a graphics file:
Then cleared out the wallpaper settings in PBI, and used the color replaced green image in the background settings, set to “Fit”
Hope this gets you what you need. I’ve attached the original decoded background, the green background and the updated PBIX file if you want to make any additional changes.
Turned out to be a far more interesting problem than I think any of us originally thought…
It ended up working out great for me too, since it took a failed attempt at something I tried to do in the Data Challenge #5, and turned it into something useful I could do with the information. I actually referenced this problem in my postmortem writeup.
I know he also deals with this issue in the ALL and ALLSELECTED videos, but start with the two above, and if those don’t solve your issue, this would be the next place to look…
