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.

Power BI Report Date Display - Snack 7

It is time for another Snack!  Let's get back to that data we loaded several weeks ago.

Go to Power BI Service online, access "My Workspace," and click on the name of the report we are working on.  

If you are using the same sample data that I am, it is probably called "FinancialSample" or whatever you named it.  The type is a "Report."

It looks like a plain old ordinary table, right now.  It is nothing exciting, so we should start forming into something that is.

If you only added the date column last time, go ahead and add more.

The last time we were here, I added the following:

• Date
• Sales
• COGS
• Country
• Discount Band
• Gross Sales
• Manufacturing Price
• Product
• Profit
• Sale Price
• Units Sold

Viewing these, some of the column names may include "Sum of ..."

This is all OK.

Also, remember the Date is going to appear divided out by Year, Quarter, Month, and Day.

Today, we are going to fix that!

1. Click the EDIT button at the top of the page.
1. You should three panels appear on the right. 
   (One or more might be collapsed.  Don't worry about that too much.)
1. Filters
2. Visualizations
3. Data
2. Click on the data table on the screen so that the table visualization is selected.
3. Under the Visualizations panel, find the column that shows,
1. Date
1. Year
2. Quarter
3. Month
4. Day
2. Click the itty-bitty down arrow to the right of where it says "Date"
1. A menu appears that shows the following (or more items),
1. Remove field 
2. Move >
3. Show items with no data
4. Date
5. ✓ Date Hierarchy
3. Click the one that says Date
1. The data table should change to display something like "Friday, July 25, 2025" instead of all of those extra columns.
1. While that is pretty, it is not really want we want for this.  An adjustment to the Semantic Model is needed to get it to look the way we really want it.
4. Choose File from the top left
5. Choose Save
4. At the top of the screen, click "Open Data Model"
1. A new tab opens, related to your Data Model aka Semantic Model
2. Click the "Viewing" button in the top right
3. Choose "Editing"
4. In the Data panel,
1. Expand your data (click the little > next to "financials"
2. Click "Date"
5. In the Properties panel,
1. Choose "Date time format"
2. Choose "*3/14/2001 (m/d/yyyy)"
6. Close this tab (changes save automatically)
5. Back in your original tab, you may need to reload your window to the see changes.
1. The date column should display all dates in a format that looks like 7/25/2025
6. Choose File
7. Choose Save

We are with this for today.  I know it seems like a lot now, but most of these things will never need touched in this report again.  Power BI will remember everything we did.