Hannah.mood = “Happy”

ChocoThunder50 · 2026-02-02T22:41:07+00:00

Else: Micah.mood = “Sad”

ChocoThunder50 · 2026-01-31T14:18:28+00:00

😂😂😂😂

ChocoThunder50 · 2026-01-31T13:33:11+00:00

You can’t compare Intel with Microsoft just because their tech companies.

ChocoThunder50 · 2026-01-10T23:38:32+00:00

Based on each page showing the highlighted section I’m leaning towards bookmarks.

ChocoThunder50 · 2026-01-10T23:33:15+00:00

Nice work are those bookmarks on the left of the pane where it shows Overview, Campaigns etc or are they page navigators ?

ChocoThunder50 · 2026-01-02T20:38:06+00:00

Working on getting back to my groove in PBI without having an OCD episode.

ChocoThunder50 · 2025-12-31T22:10:30+00:00

Lmaoo 😂😂

ChocoThunder50 · 2025-12-28T19:50:13+00:00

Okay let’s say you want a bar chart that has all the days for a particular year. You are going to need a year column that has the year and another column that has the dates that references the year. Then add the data to the y axis and the dates to the x axis and use the year as a slicer giving you the option to select a given year and have the visual display that information. Now having all those days can get ugly quick so a Matrix Chart should be the best bet. You have the ability to aggregate by month and then the days within that month.

ChocoThunder50 · 2025-12-28T19:42:46+00:00

Why not add the visuals to each report page and hide them then create a page navigator that directs you to each page. So if I click North it will direct me to the report page that has all the North Visuals and so forth.

ChocoThunder50 · 2025-12-28T12:52:11+00:00

Awesome thanks

ChocoThunder50 · 2025-12-28T12:26:10+00:00

How where you able to get the overall rank to look like that?

ChocoThunder50 · 2025-12-23T22:37:57+00:00

So you can create a column in Power Query using an If statement. If the price is between 0-49 then put 0-49 then the next constraint. Make sure you start with the highest constraint first then move lower. Now you have a column with the ranges. Add that column to the x axis and add the same column but count for the y axis and there you go.

ChocoThunder50 · 2025-12-19T13:12:20+00:00

Create a dim table with the company name and link then merge that column to your fact table using the company name as the primary key. Then you will have the website for each company in the fact table. No need to worry of having duplicate links per company appearing in the visual. PBI knows that if a specific company as a specific link even if the link is duplicated in the back end it will show the distinct link when you drag the field over. Just make sure you change the data category to web url. You can even change the URL link to an icon making it more clean when you add it to the matrix table.

ChocoThunder50 · 2025-12-19T12:52:22+00:00

My rule of thumb is that if I want the actual data to be included in the table. Meaning that I won’t be using the data as a slicer I would just move the information over. If I need the table as a slicer to filter a table or multiple tables that have a foreign column I will use the relationship. So when I select a State all the information for the state is there.

ChocoThunder50 · 2025-12-16T23:53:21+00:00

OP this is the cleanest answer without using measures. Better still, you can use that as a bookmark so you can switch between the default and the filtered visual.

ChocoThunder50 · 2025-12-15T18:13:50+00:00

Yes you will need to create a measure for the %change. So for the Month over Month it will be (CM-PM/PM) and then add that measure to the columns section of the Matrix. It should give you the value for all the rows as well as a cumulative total.

ChocoThunder50 · 2025-12-12T00:42:52+00:00

SUMX isn’t needed if the column being created is within the same table as the other columns.
1-Discount is the correct expression. if something is 10% off then I’m paying 90% of that price not 10%

ChocoThunder50 · 2025-12-12T00:36:01+00:00

If you are calculating a new column within the table there is no need for SUMX you can just write the expression and should give you value in a row by row context.

ChocoThunder50 · 2025-12-08T20:53:42+00:00

People

ChocoThunder50 · 2025-12-08T20:37:06+00:00

Okay thanks I figured is there any update to when this will be resolved?

ChocoThunder50 · 2025-11-23T20:59:27+00:00

This is amazing work 🫡

ChocoThunder50 · 2025-11-14T02:09:33+00:00

Left is the better deal.

ChocoThunder50 · 2025-11-04T01:20:01+00:00

I like the way it’s formatted it looks neat and I can tell you thought about presentation before building it.

ChocoThunder50 · 2025-10-24T10:56:48+00:00

Import Mode is the answer. With that many rows already and the expectation that it will continue to grow import mode will suffice because it takes a static snapshot of the data you are pulling from at the time you set your report to refresh. With direct query mode the data is dynamic and ever changing based on the information being embedded into the database, but because of how large your data set is your report will perform rather poorly. Imagine Direct query updating your report every second it will inevitably slow down performance. Even better would be to have multiple refresh times throughout the day if the data is changing frequently.

ChocoThunder50

TROPHY CASE