User Profile

feelie75

Helper I

Joined 5 years ago

15 Posts1 LikeLikes received

View All Badges

User Widgets

Contributions

Re: Get Data "From Folder" from Sharepoint Folder
But what if you don't have access to the ROOT of the site, but only have access to the Documents/ folder? Power BI requires a root URL, but I don't have access to that. How can you link directly to the folder or excel file???
2 years ago Place Desktop
14KViews
0likes
0Comments
Re: Connecting to Sharepoint Folder - only have access to 1 folder
This doesn't help as Power BI requires the site ROOT only, and I don't have access to the site ROOT, only the documents/ folder. Power BI won't accept a link to the documents folder, it only wants the root which I have no access to, so how do I link to just the folder or document directly?
2 years ago Place Desktop
4.3KViews
0likes
0Comments
Re: Date Slicer only showing Holidays when range changed
Yep, that was the secret sauce, gmsamborn! I just changed my SQL query to: cast(intime as Date), and then it was able to match. I didn't know that a relationship between two tables ignored the "Formatting" when I changed it to Date. That apparently ONLY changes the formatting, but the data itself still remained date/time, so the join was only happening on the 00:00:00 payroll entries. Changing the query to cast the value as date forced ALL entries to have 00:00:00 as their time component, and thus the relationship join now works! Or changing the type in the column to Date as you recommended would also work. Thanks for leading me down and confirming that. Cheers!
2 years ago Place Desktop
982Views
0likes
1Comment
Date Slicer only showing Holidays when range changed
I have a table from a query: select employeeId, hours, intime from DW.dbo.payrollstuff I have a Date Table defined as: DateTable = CALENDAR(DATE(2023,01,01),date(2024,01,01)) I have a 1->many directional relationship between the DateTable to the payroll table on the 'intime' field. I create a Table visual and pick all 3 columns. Everything shows up fine, lots of rows. I create a Slicer using the DateTable date field and...everything is fine! Default range of 01/01/2023 - 01/01/2024. All payroll rows are showing up in the table. Now, I change the date slicer to 01/02/2023, and all of a sudden, my payroll table shows ONLY entries for 1/2/2023, 1/16/2023, 5/29/2023, 7/4/2023, and 9/4/2023. Those are all holidays! I change the date slicer back to 01/01/2023, and still my table shows ONLY rows with those holiday dates. When I click on the "Clear selections" icon on the date slicer, it resets the date range, and now my payroll table shows ALL rows again. Why would changing the date slicer from 1/1/2023 to 1/2/2023 cause a weird holiday filter to happen? And why wouldn't it revert when I changed the slicer back to 1/1/2023? Why does it only fix itself when I press the Clear Selections button to reset the date slicer to it's defaults? I could NOT duplicate this using a payroll table created via DAX. It only happens when I'm using SQL to query the database. I'm doing Import table (not direct query). I can't attach a pbix since the query is internal of course. Any ideas or suggestions? I've tried to simplify this as much as I can. I even started a new power BI report from scratch, and it still happens as described above. Thanks for any ideas! (p.s. the reason I'm using a DateTable (instead of just filtering by intime) is because this project is much more complicated than what I've presented here. I have another query to another table, and I need the date slicer to be applied to both tables, so I needed a common DateTable that has a relationship to both SQL tables; I didn't include that here because I wanted to present the simplest case that still demonstrates the odd behavior.) P.P.S. - an idea occured to me. All the holidays have a TIME component of 00:00:00 as well. other entries like vacation and sick times have time components like 08:00:00 or 13:30:00. By applying ANY date filter, is that causing it not to match properly? I thought the date filter was "BETWEEN" the start and stop date? I tried changing the DateTable date format to just "Date", not date/time, and did the same for the payroll table, and made sure the format on both was mm/dd/yyyy, but the error still happens, but maybe it has something to do with the 00:00:00 on those dates? I confirm those are the ONLY dates with 00:00:00 in the data.
Solved
2 years ago Place Desktop
Need Help
1KViews
0likes
3Comments
Re: How to enable drill-down by default in Power BI?
This did not work. Where is the "Explore option"? Do you have a screenshot? I went to my app.powerbi.com, and went to the report and clicked drill down, but when I refresh the report in sharepoint, the Drill Down option defaults to off. If you can indeed get it to default to on, please provide more information, thanks!
2 years ago Place Service
12KViews
1like
0Comments
Re: Skinny bars when I add a legend, how do I stop this?
When you switch to Stacked Bars though, you lose the "Outside End" position for the data values and are forced to show Data Values INSIDE the bars, which makes them disappear for small bars, so this doesn't really seem like a complete solution, if you want all your data values to display at least. any other ideas? --- EDIT: someone else pointed out to me that you can turn on "Total Labels" in order to get the data values to appear on the Outside End when using a Stacked bar/column chart. Thanks to MFelix for that solution.
2 years ago Place Desktop
4.5KViews
0likes
0Comments
Re: only thin bars in bar chart with legend
Oh hey MFelix, that's a great solution to the missing Outside End Data Labels issue, thanks for pointing that out.
2 years ago Place Desktop
4.3KViews
0likes
0Comments
Re: only thin bars in bar chart with legend
The problem with using a Stacked Column Chart though is that you lose the option to have Data Labels positioned "Outside End". With a Stacked column chart, the value labels can ONLY be "Inside" the bars. Is there a way to have both fat bars AND Outside End positions data labels?
2 years ago Place Desktop
4.4KViews
0likes
2Comments
Re: Outside End Labels option disappear in horizontal bar chart
That link summarizes the problem as: "Sadly there is no current fix for this. Only option you currently have is to manually choose the Data colours and the Format painter!" So is the "Outside End" option really just NOT an option for these charts? There is NO "Outside end" available for the OP or myself. Is there a solution for that?
2 years ago Place Desktop
14KViews
0likes
1Comment
Re: Surpress Zero values in Charts
This worked perfect, thank you!! I'd like to add a word of caution though, I had to change the > to <> otherwise it bypassed negative values on a few months where we had negative sales due to Returns.
3 years ago Place Desktop
14KViews
0likes
0Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.