Assuming the Drab Color of the World

I needed a little something in case I got stuck with nothing to do on a recent trip.  Most simply turn their attention to that little black box in their pocket.  I usually avoid that at all costs.  This book stuck out on my bookshelf as something that might be mildly entertaining, without too huge of commitment.   I do not recall from where it came at all.  It just appeared in my collection one day; perhaps, under its own power, it invited itself into my world.  

Regardless.  While standing in the line of eternity at the airport, I began reading and quickly found it fit the bill perfectly.  Short passages within specific topic chapters outlined a diversity of opinion and speculation on the cause of this or that in the turn-of-the-century Ozark world.

One of the most striking observations came in the forward.  It not only fits the time of the writing but could easily be applied to the impact of globalization that occurred throughout much of the time after.

"Wherever railroads and highway penetrate, wherever newspapers and moves and radios are introduced, the people gradually lose their distinctive local traits and assume the drab color which characterizes conventional Americans elsewhere. The Ozarkers are changing rather rapidly just now, and it may be that a few more years of progress will find them thinking and acting very much like country folk in other parts of the United States. This standardizing transformation is still far from complete, however. A great body of folk belief dies very slowly, and I suspect that some vestiges of backwoods superstition will be with us for al long time to come."

Indeed these vestiges of backwoods superstition persist in much of our daily lives, as demonstrated by a few other passages within the book.  The very first that I encountered took me back to a saying my great-grandmother espoused frequently that was always left me a little confused about what rain and sunshine had to do with the devil beating his wife.  I remain perplexed to this day too.

The next I encountered came straight from my parents mouths.  It is but another that leaves me wondering.  Why Bread and Butter?

Some may be more familiar with the "Salt and Pepper" variation.  While this one seems equally unfounded, the book does discuss beliefs surrounding various aspects of good and evil associated with having, keeping and freely giving salt away to another.

Then there are some that do not match perfectly to well known phrases, though it is easy to tell from where they may have had their beginnings, as with this related to finding a pin.

I could probably snapshot most of this book, and may yet include more of these phrases in the comments as I go along.  It is a fun read, to the say the least.  Some phrases have no specific origin and some are meant to keep children busy in the days before radio, television, or any sort of other technology. I neglected to snapshot this point but it amounted to sending children to go count the freckles on the face of another to find out how many days until summer or some such thing.

Randolph, V. (2012). Ozark Magic and Folklore. Dover Publications. (Original work published 1947).

Tao Verse 16

The great truth of Nature is Tao.

Mineral Baths to Mountain Bluffs

Our Anniversary Escape this year led us to Hot Springs in Arkansas.  The biggest motivator seemed to be that every other attempt to visit the namesake placename has ended in some disruption or another.  The most recent attempt north of Yellowstone in Montana found the place had closed for the season the weekend just prior to our arrival.  This turned out very similar to other attempts too, though not a complete failure.

It is an interesting little town to explore and soak in a little, quite literally and of course, figuratively. While three days felt like the perfect amount of time to get a good taste of the area, a longer stay would be needed, if one were to have an interest in conquering things like the 21 km Sunset Trail.

Hiking was not at the top of this agenda this time, though we did afford time for the Gulpha Gorge Trail, after pausing for a ride up to the top of the Mountain Tower for a look around the valley.  Most of the remainder of the time involved parading up and down Central Avenue, relaxing in a mineral bath and enjoying some delicious German food.

Local art proved itself an unexpected highlight, featuring an array of massive murals climbing three or four stories high. These pops of fresh paint felt like a modern dialogue against the city's historic backdrop, appearing in almost every corner of the downtown area.

Leaving the city behind, the second half of the adventure turned north into the Flatside Wilderness of the Ouachita National Forest.  The detour was mostly unplanned, beyond knowing of a waterfall there that just happened to be along the way.  We found the cascade mostly dry, though an interesting space in the middle of nowhere to visit.  The trek in and out of the location, crawling up and the rough roads offered their own adventure, proving once again that the journey is just as important as the destination.

Returning to our home away from home in Heber Springs offered time to enjoy friends and family and scoot up to Batesville Motor Speedway for the annual dusting at .  It was a bit cooler than last year, and the wind was not quite as tuned into the direction it should have, but not awful.  The drone of engines and a good coating of red clay just feels right on a cool spring night.

A day on my own led me to the North Sylamore Creek Trail.  Road conditions deterred previous transports from enjoying this piece of scenery.  The short route down to the Allison Trailhead is not always in the best of conditions.  This time, well-prepared with a high clearance vehicle, the road presented itself in much more appropriate fashion.

With transport parked firmly in place, a secondary obstacle loomed.  The creek itself it not much where the trail first meets the bank. However, the Forest Service encourages a trek north from there about 100 yards and cross at a much deeper section.  It is undoubtedly one of those little counterintuitive trail quirks.  Perhaps during high water, it is a shorter distance but then again, much deeper still.

Once on the trail, the landscape changes as the trail climbs steadily to meander northerly above the river, enabling spectacular views of where water likely spills over the edge of the bluff high above, in several locations; that is, in damper conditions.  The stretch defines Ozark geology, with hidden caves and weathered karst littering the length of the journey.

After exploring roughly 4 of the 30 kilometers associated with this trail, it was time to think about heading back since I had no clue how long it was really going to take and there were other plans for the evening hours.  Emerging from the wilderness earlier than expected offered time for a quick jaunt over South Sylmore Creek and its swinging bridge.

The road back to Heber Springs from Mountain View takes about as much time as crossing from one side of Kansas City to other.  It is undeniably more interesting though, even if the state continues to push to straighten out the roads and remove the deep valley dives.

Conversation and a good meal brought things to a close for the day, so much so that we completely  lost track of time.  We realized too late that we missed the change to jump over to Sandy Beach to enjoy the sun set on another enjoyable journey into Arkansas.  There is always another chance.

The drive homeward did not really stand out all that much.  Anticipated afternoon storms, coupled with a return to work looming on the morning horizon the next day encouraged arrival at an earlier than normal time.   It had  been another good journey, leaving us with good memories, multiple new additions to The Ozarks collection, and a little red clay all around.

KC 2 Atlanta & Back

Downtown Atlanta proved an interesting place to explore for a few days, while attending FABCON / SQLCON 2026.  More compelling than anything else, I had the opportunity to capture a few views for the collection from 9 km or so in the air.

Basecamp held its own unique history, though not much is left of the old place beyond a high-rise with a spectacular view from the outdoor pool on the 19th floor.  With a Margaritaville attached, a Waffle House a block away,  Centennial Park sprawling across the street, and the Georgia World Conference Center lie just on the other side  of that, it proved itself the perfect location.

In my spare time, I wandered about a 2 km radius from the location, taking in the local art and dropping by the state capitol building.  The space between has definitely seen better times, though appeared as though it were rebuilding to return to those glory days. It was an interesting town, and very walkable in the daylight, though I am not sure I would return with the sole intent on seeing Atlanta.

Tao Verse 15

Those who have Tao want nothing else.

Mason Jars, Dishware, and Mowers in the Forest

Hiking about one of my favorite spots this past weekend, I got to thinking about a previous discovery there, and thought to check in on it.  I almost forgot where it was.  I checked one spot and then another, before a crunching sound underfoot that did not align to the sound of leaves confirmed the location.  

Brushing away the dead leaves, I noticed some of the pieces of mason jars previously noted.  There were not quite as many as before and the rusting remnants of the vehicle that contained these artifacts were nowhere to be found.  That is not surprising.  At the time, I had made the mistake of posting about this little discovery on Twitter. Shame on me.  Lesson Learned.   

A couple of new pieces emerge this time, with a few more light brushes.  They were only lightly covered in soil and appeared to be part of some sort of dishware.  Turning the piece over, fading paint appeared on the artifact.  It was not much thicker than a nickel and appeared to be hand-painted.  An AI search on this image indicates:

"The image displays a shard of antique porcelain with significant crazing, which are the fine cracks in the glazed surface and a common sign of age in old ceramics.  The pattern appears to be a transferware design, potentially from the 19th or early 20th century."

The second piece was a bit larger and probably a flanged bowl of some sort.  Judging by the diameter and the convex interior curve, it might have been a old wash basin.  An AI search on this image indicates:

The object in the image appears to be a shard of vintage ceramic dishware, likely stoneware, featuring a cream-colored glaze. The shard shows a thick body typical of 19th or early 20th-century pottery, with significant crazing (fine cracks) in the glaze.

Coloring, texture, and general make indicate both items are related, beyond just their location. They were rescued and cleaned under hot water and placed in a plastic bag for preservation.  I feel as though I may need to excavate a bit more of this situation to learn more. 

This is the most anyone will get to know this time.

The backstory on this weird little archaeological find begins after a series of heavy rains a couple of years ago, when I discovered an interesting artifact along the trail of one of my favorite hiking spots.  Lying perpendicular to the trail in a ditch created by downhill drainage, I noticed a chunk of metal sticking up and went to examine.  Brushing away leaves and dirt uncovered what appeared to be the decaying bed of an old pickup type vehicle from the 1930s.  The tailgate remained mostly intact, though sides and bed were one. Multiple broken mason jars lay against a corner of where one of the remaining corners met the tailgate.

It appeared that someone had been driving along and had broken down while ascending the hill.  The general direction of the vehicle indicated progress from the direction of Liberty towards Gladstone. They apparently just left everything there, though that seems a bit odd for someone to do.  Did they go looking for help or otherwise and simply forgot how to get back?  Did they just give entirely?  Did they get caught transporting moonshine?  Did they die here?  What exactly happened?  Scant research uncovered nothing.

Leaving this little find in place and undisturbed, I took a couple of photos and unwittingly made a post about the discovery on Twitter.  Returning to the site a few months later, it should have been no surprise to discover that someone had been rooting around, though it remained mostly undisturbed.

I posted on Twitter about it, at the time. I should have never done that and won't make the same mistake twice.  Almost everything described in this back story has vanished.

A few hundred yards from there, an old mower lay quiet on the forest floor.  This land was used for something at one time, or it was junk yard.  Hard to tell just now.  More research is needed.  Below are a few shots of that in the last couple of months.

Tao Verse 14

Beyond the sense lies the great Unity.

SharePoint List Deprecation in favor of Rules

Microsoft continues to align with the Google way of doing business, abandoning processes that are user-friendly in favor of a more awkward way of doing things.  It is simply continuing technical stupidity.

Microsoft strives to deliver utmost value to our customers through modern, optimized, secure solutions in this newly evolved world focused on digital transformation. As part of this evolution of Microsoft 365 solutions, we will be retiring SharePoint Alerts and believe Microsoft 365 customers will be better served by modern notification solutions based upon the Power Automate platform or SharePoint Rules. - SharePoint Alerts retirement - Microsoft Support

Microsoft, you believe wrongly.  Alerts were simple and straightforward.  We now have to setup 3 rules to accomplish what one alert did perfectly.  Additionally, the Rule does not include information that the Alert included, which causes users to have to click-through to get to that information.  To get that information, you have to create an Automation.  I can get through it, but it is not exactly a simple process for nearly all of my user community.  This is not helpful.  Thanks for piling on more work for me, Microsoft.

I suppose that I should be thankful they are not ditching SharePoint completely.

Golden Sands Ranked First

This view greeted us in the morning during our stay at Great Sand Dunes National Park & Preserve last year, and just ranked first in a little photo contest for "Golden Sands" on PulsePX. 

Requirements for submission expected one to "Explore the textures of the dunes. Capture the shifting patterns of sand in deserts or on beaches. Use the low angle of the sun to highlight the ripples and ridges, creating a warm, textured, and minimalist landscape."

 It was much more than we expected to see that morning, after overnight cloud cover denied any dark sky star-gazing. 

Year One in the Crosstrek

One year in the Subaru and it has been a good car.  It is good to run down unpaved paths with a great deal more undercarriage confidence than the previous vehicle.  I remain unimpressed with the level of technology in the vehicle and since purchasing it have discovered that many others are also unimpressed with level of technology in any vehicle.  Some things are acceptable; other points are purely ridiculous.  

As an example in 2024 model year, Subaru moved the climate controls to the touch screen.  This was a terrible move and not user friendly at all.  One has to physically look at the screen to see where to touch to turn the fan up or switch the output. This is a terrible user experience. There is also the case of the frost bomb that awaits the unsuspecting solo driver in cold weather.  

There a few other things do not really live up to expectations, but are mostly tolerable.  Gas mileage is not what it should be or could be.  If Ford can get 40 mpg out of a 2015 Focus, surely we could do a little better ten years later. "Eyesight" could be a little less helpful.  There is no need for the car to drive itself.

The chief complaint is the relative cheapness of the vehicle, which is starting to stand out.

Some things are what you might expect out of cheap car.  Scratches under the door handle, from repeated use are awful.  The above image displays the issue.  It took 8 years for my previous vehicle to even come close to looking like this.   Why do other cars not have this issue?  Is it cheap paint?

Some things you do not expect to see in the upgraded version of the cheap car.  The Limited has a Leather arm rest in the center console.   The photo above displays it poorly but a noticeable impression on the corner of the side of the driver has started to appear.  The Premium version, owned by a friend just as long, does not have this problem.  It has a much durable center console arm rest.  Subaru should have used the same framework and covered that with leather.

Lastly, the backup camera, and Subaru is not alone on this front.  The only camera I have encountered that does not have a problem with dirt and grime all over the lens was the 2015 Focus.  Ford seems to be the only manufacturer that knows how to place a camera so it does not get dirt all over it; that is, at least on that year and model.  Subaru did ensure that you have some means of cleaning off the camera,  even if it is mostly ineffective, amounting to drool running over the lens.

Those are the only complains so far, for the past year.  I am sure there are some that I missed that are trivial in nature.  It is a good car though.

Tao Verse 13

Be wary of both honor and disgrace.

Last Trading Day of the 2025 Year

image borrowed from MarketWatch.com

Here is what potential last trading day purchases for me look like this year.

• O - Realty Income ... Stable with a 6.9% dividend that is paid out monthly!
• CAG - ConAgra - Low Price - 8% dividend
• EPD - Enterprise Products Partners - Stable with a 5.67% dividend!
• UPS - United Parcel Service - Under $100 and a 6.6% dividend!
• EDITAS = Cheap!  $2.  This is a slow to grow Genetic BioTech and purely speculative on my part.

Others I am watching that are purely dividend oriented

• BMY
• CL
• CLX
• CPB
• GFS
• GIS
• POR

One that I cannot figure out is ASTS.  To buy or not to buy, that is the question.  So far, my return on this one is nearly 2000%!!  I cannot help but feel it is over-priced, but it just keeps going up!

Where is NVDA?  It is over-priced.  My opinion is not to bother.  I cannot make any more of the significant gains that it already has and is a waste of time.

Historic Encounter at Shawnee Bend Bluff

 

A trip down to Warsaw offered up a fine place to burn off a little energy and explore a new trail that skirted the bluff line at Shawnee Bend on a clear sunny day.

Tranquility stood out in abundance on this Wednesday, enabling most of what I captured on film. One couple had just finished up their morning walk with their fluffy little friend, while another two were only yard away from departure, leaving the trail entirely to me and my striped sidekick.  The sun shone brightly in the wrong direction at the bluff though, coupled with haze from smoke in the area, foiled any attempt at a decent capture.

An intriguing set of ruins offered time to reflect on the history of the space before the lake came into being.  Somebody put a lot of effort into a little cabin here; in particular the fireplace mantle.  It would be interesting to hear the story, though it is probably lost to time forever.

Afternoon Escape to the Lake with Catfish

 

Skipping out of town on a random Wednesday afternoon, I headed south into the Lake of the Ozarks.  The mission for the the day was to meet with an old friend I had not seen or heard from in a very long time.  

The journey took about as much time as expected, with the winds and temperatures of a looming cold front chasing me the entire way.  The cloudy skies did not follow along at all, thankfully.  Clear blue skies dominated the afternoon in this neck of the woods.  "Chances R" hosted an excellent lunch for us, where the Catfish were extremely well fed and very delicious.  

While the time and the food were more than we really wanted to leave, rampaging deer populations intent on impaling themselves upon any vehicle available generally encourage departure in sufficient time to ensure a keen ability to spot them before the opportunity arrives.  

I had intended to simply return the way I had come.  It had been pleasant enough rolling down MO-135 but I missed my turn, semi-intentionally.  Heading north through Gravois Mills, I found a once booming economic hub now a shadow of its former self, though still offering the perfect sort of escape on the edge of the Ozark insanity.

The remainder of the journey proved mostly unremarkable.  A pause in Sedalia offered up an interesting older piece of art on the side of a building.  Beyond that, I found little else worth a pause, only a detour.  Someone had fouled up the flow of things along US-50 right at MO-13, forcing a detour to the north.  This forced an encounter with I-70 and major construction, somewhat ruining what was other was a great out on the road.  

Tao Verse 12

the Sage is led by his inner truth and not his outer eye

Power BI Report Mobile Layout - Snack 20

In this mobile world, you might want to enable a cleaner view of reporting for those interested in accessing reports through the Power BI app.

You didn't know there is an App for that?

There is indeed.  Look it up in your favorite app store and access all of your reports on the go, after we get this ready, of course.

Let's get going ... 

1)  Jump into your report and switch to EDIT mode.

2)  Click "Mobile Layout," at the top of the screen, just underneath the title of the report.

-   A screen appears offering the opportunity to "Create a mobile layout."

-  Do NOT click that button that says "Auto-create mobile layout."

-  Try that some other time.

On the right of the screen are two panels, "Page Visuals" and "Visualizations."

The "Page Visuals" panel displays all the elements from the report created.

The "Visualizations" panel enables you to modify the element for better visibility in mobile view, without impacting the original desktop display you created.  To do so, click the element you want to adjust, and the panel will populate with options available for modification.

3) From the "Page Visuals" panel, click, drag & drop the little boxes out onto the white area that looks like mobile device.

-  Take them one at a time.  When they appear on the mobile device layout, gray handles appear enabling you to resize and reposition the element. Position and size it, then move on to the next.

-  It will not let you stretch off screen, thankfully.  

-  It will let you lay them over the top of each other though, so beware of that.

-  Hover over and scroll on the mobile device layout to get more real estate.  

4)  File > Save

-  To get back to the original Desktop Layout View, click the icon in the lower left of the screen that looks like a computer screen.  

 

. . .

I hope you enjoyed tagging along with this little exercise.   This concludes the last regular installment of these little snacks.  There will be other editions, just not quite as frequent, I think.  You never know.

There is a lot more that can be done in Power BI.  We hit all the core elements though.

Everything else can be figured out by clicking around, asking around the interwebs, or your favorite Artificial Idiot (AI).  The latter is usually right, most of the time.  You know how it is.  You are doing 100% better if you figure it on your own though.

Microsoft hosts an excellent support community (Power BI forums - Microsoft Fabric Community).  The folks over there can answer just about any question or at least work through figuring it out with you.

Additionally, Guy in a Cube on YouTube is an excellent resource for tips, tricks, demos, feature reviews and really digging into the guts of Power BI, and they are more interesting than most.

Tao Verse 11

when a thing has existence alone it is mere dead-weight

Power BI Formulas and Calculations - Snack 19

Today, let's talk a bit about Calculations aka Formulas, which are called Measures in Power BI.  They are not a whole lot different than their counterparts in Excel.  There are some distinct differences though and too many to discuss in this forum.

Everything done in the report so far is nice but does not address one concern.

    What if the data does not display some calculation or another?  

We have to add it ourselves.

    Do we add it to the original spreadsheet before we connect the spreadsheet?  

You can but it is not quite as efficient.

    What if we do not think about this calculation until after we have already connected it? 

That is what we are about to talk about.

    Can a calculation be added to our spreadsheet after we have connected it to Power BI?

Yes, but it is awkward at best.

The best way to handle this situation is to do nothing with your original spreadsheet.  Best practice is to keep your original data as it was originally sourced and just do a little coding.

    Wait a minute, I did not bargain for that!  

Don't worry.  It is relatively easy, and I am going to tell you exactly what to do.

Let's say for instance that you want to know the difference Sales and Gross Sales.

In Power BI Online,

1) Access the report we have been working on.

2) Choose EDIT

3) Choose OPEN SEMANTIC MODEL (a button on the top row)

The view will change to a little table showing all of the table columns.  There will be a green bar at the top that says, "You are in Viewing mode and changes will not be saved." 

4) Switch to EDITING by selecting the green menu button in the very top right of the screen that currently says "Viewing"

BEWARE! Keep in mind your changes will be permanent and automatically saved. 

5)  Right-Click on the table name in the Data Pane on the right.

6) Select "New Measure"

A new box appears at the top of our space with red check box and a green check box which says "Measure =       "

In the following steps, we are going to put in the following measure:

    Sales Difference = SUM(financials[Gross Sales])-SUM(financials[ Sales])

Pay close attention to what is happening as you type. 

7) In the Measure box type "Sales Difference =" over the top of "Measure =" 

Nothing happens. Hrmm.

8) Type "SUM" then press <TAB>

Notice that as soon as you began to type, a drop-down of options appears.  Those are other expressions that you can use.  We are only going with SUM for right now.

Also notice that a "(" was added automatically for you when you hit <TAB>

9) Type "Gr ..."

The name of that column from the table appears suddenly

10) Press <ENTER>

11) Type ")" to close the argument.

Sorry.  It does not know when to stop, so you have to tell it.

So far, we should look like "SUM(financials[Gross Sales])."

That is not enough to get us there.

12) Type "-"

Nothing happens.

13) Type "SUM" and press <TAB>

14) Type "Sales"

Now we have a problem.  There are two to choose from.  We already used one of them though, so that narrows things down.

15) Click the one titled "financials[ Sales]"

16) Type ")" to close the argument.

17) Press <ENTER>

If you did everything right, you should Power BI "Working on it ..." and then your Measure will appear in that box, without any errors or weird red lines underneath parts of it.  If it has those things, erase it and start over.

If you cannot get it to work.  Grab the full formula above and paste it in that box instead.

18) Switch back to "Viewing" mode by clicking that little button in the top right of your screen that currently says "Editing."

Notice that there now appears to be a column in the table for "Sales Difference."  It is actually only a formula that will consistently calculate the difference between those two columns everywhere you use it.  It will act like a column but really is not.  It is only pretending.

What we have done is tell Power BI that every time we drop in this little pretend column, we want it to calculate the SUM of Gross Sales, calculate the SUM of Sales, then subtract the latter from the former.  Easy, right?

You can now go back to your report and use this little formula anywhere you like; well, most anywhere.  That is another story for another time though.

A couple of other related stories are New Columns and Visual Calculations.

When we first started with this, about the time of the right-click, you probably noticed you can also add "New Column."  That is a whole different situation than what we just did, though it can work much the same, though on a row-by-row basis.

What is the difference?  

Days of argument over which is more suitable for conditions in the report.

Stick with DAX for now.

Oh, I probably forgot to mention, that is what "code" we were writing.

While a lot of others try to define catalogs of the various expressions available for DAX, Microsoft has their own and is probably more reliable than others.

Data Analysis Expressions (DAX) Reference - DAX | Microsoft Learn

You might also discover or someone else may also tell you that you can simply use a "Visual Calculation."

You can.  It is easier.

Understand that they only apply to the visual selected though and cannot be reused easily.

That is the best I can frighten you on this Halloween.  

Happy Measuring!

Power BI Report Titling - Snack 18

It feels like the only thing really missing from this little report is perhaps some sort of title.

Let's add one!

1) Jump into EDIT mode on the report.

2) Click "Text Box" at the top of the screen.

A box appears with an accompanying Format Box.  If you have any experience at all with Microsoft Word, you already know what to do here.

3) Give the report a title by typing into that text box.

4) Choose whatever formatting options make you happy.

Simple, right?

However, suppose for a moment that you or the person(s) accessing the report would like a date on the report that reflects whatever year, month or day is selected.

That little Format Box is more powerful than you realize.

5) In that Format Box, click "Value."

The format box expands so that you can "Create a dynamic value that updates with your data."

This is where you really to know your data and how you might query it to answer the first question in that box, "How would you calculate this value."

It also helps to know how Power BI wants you to ask this question.  Sometimes, you have to play around with the word order to get it to do what you want.  I already did that for you here.

6) Type in that box "Latest Date Financials"

7) An option displaying the very same thing you type should appear below that.   Choose it!

Just below that, where says "Results," you should see "12/1/2014"

Beneath that is a drop-down to choose how to display that result and other associated formatting options.

Finally, the box at the bottom enables naming the value.  This is handy if you have a lot of different values driving that title and/or description and need to keep them all straight.  You can literally write an entire diagnosis in that text box, using nothing but defined values.

Let's leave that last one as #Value for now.

8) Click Save on the Formatting Box.

The date should appear in your text box.

You might need to format it to match any text you placed before that.

9) File

10) Save

Let's test it out.  Click on "Qtr 2" in the bar graph and the date just created should change to 6/1/2014.  If it did not, start over. 

Fun, huh?

You can also add many of the options that visualizations have to that text box. If you have it selected, what is normally the Visualizations Pane has become the Format Text Box Pane.  That is not the same formatting just covered; it is for the box itself.

That is all I got this week.  

While it feels like that is all that is left to do, we still got a few things to talk about, so look for another episode soon.

Power BI Report Filtering Options - Snack 17

There are multitude of ways and means to filter in Power BI.  A few snacks back, we talked about how the visualizations can filter one another. Additionally, specific visuals can be included for nothing more than filtering.  If you scan through the visualizaiton icons, you will find such filter called "Slicer."

Slicer enables you to choose a datapoint or set of datapoints to use in filtering the page.

Let's try it out.  Access your report and jump into EDIT mode.

1. Click out in the blank space so that you are sure to have nothing selected.
2. Find and click the SLICER visualization under the Visualizations tab.
3. Drag and drop SEGMENT from the Data Panel into the Visualization Panel Field
1. You should see the visualization populate with the market segments.
1. Click the boxes and watch the changes
2. Unclick all boxes
4. Format your visual
1. Under Slicer Settings, you will see that this visual has three.
1. Vertical List
2. Tile
3. Drop Down
2. Cycle through them and see what happens
3. Choose Drop Down when done playing around
1. As with other visuals there are other modifications you can make it look just how you like.
5. Move and Size your visual to make the most of the space on the page.
6. SAVE!!

You are probably thinking you can squeeze a lot onto the page and manipulate quite a bit with filters.  

That is correct, but it can get busy, and space is limited.  Eventually you will find yourself lacking sufficient real estate, especially when your users start telling you how they would really prefer to slice and dice your report.

That is where the Filter Panel comes in handy.  This is always present and can be populated in any way for a single visual, a single page, or every single page in the report.  You can guess what they by their section name in the Filter Panel.

Try it out!

1. Click in the blank space of your report again to ensure nothing is selected.
2. Drag and drop the following fields from the data panel to the little box under "Filter on all pages"
1. Date
2. Discount Band
3. Product
4. Segment
3. SAVE!!

There only a couple of parameters you can mess with on these. 

• Require single selection
• This will force the user to choose only one item, though they can still CTRL+Click to choose more.
• Filter type
• Basic filtering
• Offers a list of choices
• Advanced filtering
• Offers a sort of query view enabling more exacting choices
• Relative Date & Relative Time
• Only available for Date fields
• Enables a user to choose a period
• In the last ... however many whatever
• In this ... whatever
• In the next ... however many whatever
• requires futures dates

You can also hide these filters, which is useful if you want to present a very specific view for a visual or for a particular page.  Hover over the cards in the Filter panel and you will see tiny little icons that enable you to ...

• Expand or collapse filter card
• Remove (the filter card)
• Lock (the filter so it cannot be changed)
• Hide (nobody can see this filter card when it is published)

That is all we have for today.  Happy Filtering!

Screenshot includes the Filter panel this time for reference.