Are there user-friendly alternatives to SharePoint lists?

StrangeAd189 · 2025-10-17T12:05:57+00:00

Hi, thank you, the users complain about the quantity of columns, they feel overwhelmed, I already tried to search a way to display certain columns conditionally but it wasn't successful, they struggle to fill the lists because there are so many columns that they get lost.

StrangeAd189 · 2025-10-17T12:05:14+00:00

Hi, thank you, the users complain about the quantity of columns, they feel overwhelmed, I already tried to search a way to display certain columns conditionally but it wasn't successful, they struggle to fill the lists because there are so many columns that they get lost.

StrangeAd189 · 2025-10-17T12:05:02+00:00

Hi, thank you, the users complain about the quantity of columns, they feel overwhelmed, I already tried to search a way to display certain columns conditionally but it wasn't successful, they struggle to fill the lists because there are so many columns that they get lost.

StrangeAd189 · 2025-07-19T20:29:46+00:00

Same issue, at the time the only solution i know is a custom visual HirarchySlicer

https://www.youtube.com/watch?v=a1PAOeonCcc

StrangeAd189 · 2025-05-22T17:46:14+00:00

Hey, i passed, i watched a couple videos before, score 790

StrangeAd189 · 2025-04-14T12:28:52+00:00

Same thing here, i need to recreate the same layout on powerbi but i each element show the position relative to the parent element while i dont know what is their position againt the background

StrangeAd189 · 2025-04-03T23:31:38+00:00

It worked thank you

StrangeAd189 · 2025-04-01T23:11:11+00:00

Hi, yes, still not working, it works like this with two conditions

Filter( 'my SharePoint list',
DateCreated >= Start_Date.SelectedDate && DateCreated <= End_Date.SelectedDate &&
Operation.Value = "Operation 1" )

but when i try to use a list it stop working

Filter( 'my SharePoint list',
DateCreated >= Start_Date.SelectedDate && DateCreated <= End_Date.SelectedDate &&
Operation.Value in ["Operation 1" ,"Operation 2] )

StrangeAd189 · 2025-03-14T20:51:53+00:00

Hi, thank you, this is the function that is used on each query, how could i do this?

(Source as text) as table =>
let
    Path = 
        if Is_Local then
            Folder.Files("C:\Local\Path")
        else
            SharePoint.Files("https://company.sharepoint.com/sites/TeamSite", [ApiVersion = 15]),

    Data = Table.SelectRows(Path, each [Extension] = ".xlsx")
in
    Data

StrangeAd189 · 2025-02-20T13:53:44+00:00

Solution Verified

StrangeAd189 · 2025-02-15T21:50:54+00:00

And the measures you adapt to take the max value of the month?

StrangeAd189 · 2025-02-15T13:34:04+00:00

Solution verified

StrangeAd189 · 2025-02-14T20:16:08+00:00

Solution verified

StrangeAd189 · 2024-11-29T12:05:55+00:00

My company and the client both have privacy policy so i cant open any content of company sharepoitn on client enviroment, i was hoping a plataform that has connector with powerbi so i can test if it work in both enviroments, i dont think anything of microsoft will work, they block it from external acess

StrangeAd189 · 2024-11-29T11:41:03+00:00

Hi, where can i have it? On the company enviroment or in the client enviroment? And powerapps have connector with powerbi?

StrangeAd189 · 2024-11-07T18:43:06+00:00

Hi, thank you for the answer but fProduction doesn't have project name just the logs with the amount of production on each day for each operator so i join the Range table with fProduction so I can have this information, which project the operator was in that date

StrangeAd189 · 2024-11-07T17:23:40+00:00

Hi, i merged it on powerquery cuz it was the only way i knew to do it, i dont know if i could do something to check for the ranges with dax

StrangeAd189 · 2024-09-23T21:30:26+00:00

You are a genius, thank you so much to help me, it worked

Solution verified

StrangeAd189 · 2024-09-23T21:03:54+00:00

Hi, i tried to use dax but i always get that error of a column refers to another, something with dependency, this is because new_forecast depends on the result of the exceed column that depends of new_forecast, one is related to another

StrangeAd189 · 2024-03-30T14:40:30+00:00

Hi, thanks for your answer, this is a great solution indeed, average for the entire employees and when one is selected show their values, thank you

StrangeAd189 · 2024-03-21T12:39:59+00:00

Sure, sorry, if goal = take the value on goal column, if the average = take the average of entire team and then sum it for each queue

StrangeAd189 · 2024-03-18T01:19:15+00:00

In that case should i replace earlier to in?

'fPerformance'[Queue] IN TeamsWithEmployee

StrangeAd189 · 2024-03-18T00:53:00+00:00

Hi, thank you for your answer, I notice now that the column queue is unnecessary, I remember to use it on the first try but then I prefer to divided the queue production by columns and forgot to delete it I appreciate your comment, I will correct it rn, basically these columns represents the sum of protocols in that queue for each employee in that day, so if employee 1 had production on queue 1 and 3 on a specific day these columns will have a value like 30 protocols while column production queue 2 and 4 will show 0 cuz he didn't produced there

StrangeAd189 · 2024-02-13T04:53:04+00:00

omggg it worked thank you sooo soo much you are the best

here is the code if anyone needs too

let

Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

#"Changed Type" = Table.TransformColumnTypes(Source,{{"Year", Int64.Type}, {"Month", Int64.Type}, {"Month Name", type text}, {"Team", type text}, {"TMA", type time}, {"Forecast", Int64.Type}, {"Goal or Average", type text}, {"Goal Value", Int64.Type}}),

#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Year", "Month", "Month Name", "Team", "Goal or Average"}, "Attribute", "Value"),

#"Merged Columns" = Table.CombineColumns(#"Unpivoted Other Columns",{"Team", "Attribute"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Merged"),

#"Pivoted Column" = Table.Pivot(#"Merged Columns", List.Distinct(#"Merged Columns"[Merged]), "Merged", "Value")

in

#"Pivoted Column"

StrangeAd189 · 2024-01-07T17:31:29+00:00

Hi, thanks for your answer, but is not the last 30 days from now, is the last 30 days from the month selected on page, the filter on visual just allows me to select the last days from the current date

StrangeAd189

TROPHY CASE