Power BI Report Sorting - Snack 9

Welcome back to snack time!  This one will be a little lighter than the past several.   Today, we are just going to do a little sorting.

Let's get back to our report.  Remember that you have it stored in "My Workspace."

Looking at our table, we probably want that sorted differently, or maybe we don't.

Sometimes we have the data just as we want it and prefer to leave it to the user to do the sorting.

Hovering the column names in the Table visualization, a little black arrow appears beneath the column name.  It points in the direction that data is currently sorted.

• Click on a column to sort that column.
• Click it again to sort the other way.
• Shift-Click to include another column in the sorting. 
• This sort the first column chosen, then the second column.
• Shift-Click the second column again to sort that second column in the other direction.
• Shift-Click to include a third, fourth, or fifth column.

None of this will remain this way.  The default view dictates otherwise.

In order to establish the default sort on this visualization, you will need to access "Edit" mode, sort the visualization as you would prefer it to display using the methods above, then "Save."  Your chosen sort will be the default display.

Another option, if you only one column sort is required, choose the ". . ." menu at the top right of the visual, then choose "Sort by," then the field you want to sort on.

Notice that above "Sort by" is "Sort Ascending" and "Sort Descending."

That is all for today!  Happy Sorting!

Google Photos tries to Cheat Users

Google is playing tricks with their app, very likely in an effort to force users to buy more storage. 

When Google reversed their decision to offer unlimited storage back in June of 2021 ,many users left the platform.  They migrated to destinations they were already using, or to other platforms that simply continued to offer unlimited storage.

Google did offer users the ability to save storage space, using a setting within the app called "Storage Saver," which compressed photos and videos slightly.  Many kept using Google Photos leveraging this option and it worked great.

An update to the app on May 25, 2025 changed that setting.  This was confirmed with several users.  Of course, everyone had a slightly different date.  That was the date that everything began to backup at "Original Quality," using more storage than it should have been.

This sure feels like "as designed."  Folks are finding different solutions and backing away from the "The Cloud."  What better way to force people to make a choice than to tamper with their settings?

If you have fallen victim to this scam, you will need to adjust the settings within the App on your device.

Be aware that you will need to do this for every app on every device that you backup photos from.  If you use Desktop on your computer, you will need to do it there (and in every browser you use to backup).

Tao Verse 8

 

One who lives in accordance with nature does not go against the way of things.

Power BI Report Theme Change - Snack 8

Last time we visited, we addressed the formatting of the Date column.  

It got a little ugly, but hopefully everything worked out for you.

Getting back to My Workspace in Power BI, let's see what else we need to do.

Go ahead an open your report; again, mine is called "FinancialSample."

There are multiple things that stand out about the data.  However, the table visual itself does not seem to stand out too well.  It is difficult to discern where that visual begins and where it ends.  

Let's fix that!

The more that you use Power BI, the more you will find that it is extremely helpful to know exactly where those visualization boundaries are.

Viewing your report in My Workspace in Power BI, 

1. Choose "Edit" from the top menu
2. In Edit mode,
1. Choose View
2. Choose Theme
1. A window should appear with some rather colorful themes.
2. I know you really want to choose your own, but for these demo purposes, 
3. Find the one with the blue background.
1. If you hover over that one, it should say "Tidal"
1. I use this one (Tidal) exclusively, because it matches organizational colors almost perfectly.
2. Click "Tidal"
1. The table appears over a blue background now.
2. Also, the boundaries for your table, as well as the handles that enable resizing it should also be more apparent.
1. This just makes everything a lot simpler.
3. In the top left of the screen,
1. Choose File
2. Choose Save

That is all we have for today.

Still hungry? 

If you really want to change the Theme to colors that better match your personality, repeat steps 1-3.

Should you choose one with a white background, I highly recommend adjusting the background color, so you see visual boundaries better.  You can always change it back to white later.

1. To change your background ...
1. Click on the background of your report so that you have NO visualization selected
1. How do I know that I have NO visualization selected?
1. The Visualizations pane will only have 2 icons at the top
2. At the top of the Visualizations pane,
1. Click the "Format your report page" icon (looks like a paper and paintbrush)
2. Select "Wallpaper"
1. Ensure the box for "Image" says "Browse"
1. If it does not, click the "X"
3. Choose a color from the color pallet
3. File > Save

Yes, you can use a picture for a background instead, if you really want to.

You probably noticed that there are two similar choices in there for backgrounds.

"Canvas Background" is the area within the report page. The boundaries of that are the dashed line going around the report screen.  You cannot move your visuals past that line.  That is the "Canvas."  You may have to adjust the transparency on this to see it happen.

"Wallpaper" refers to the area outside the report canvas.

Looking at how I have been doing this for the last bunch of years, it seems that I only use the Wallpaper with the Canvas background Transparency set to 100%.

Why?

I don't know.  The dashed line surrounding the Canvas is good enough for me to know where my layout space ends.

Until next time, play around with it and see what works best for you.