User Profile
Lajouac
Advocate I
Joined 1 year ago
User Widgets
Contributions
Re: Develop Power Query outside Power BI or Excel
Thanks! I am far below a million rows. If I have 100k, that would be the maximum I think. Regarding your other points, I am not sure if I get them all, but I may sometimes have several consecutive queries, like 10 different queries to give me one final table. But I don't think this is too complex.3.4KViews0likes3CommentsDevelop Power Query outside Power BI or Excel
Dear all, I came across this Reddit post, and I'm interested in hearing what the Power Query community actually thinks about it. The answers to the post basically claim that Power Query isn't built for complex transformations and suggest we should move to Python or SQL environments instead. Like the post's author, I work primarily with multiple Excel files stored on SharePoint, which I transform using PQ to create solid star schemas for my reports. But the more I use it, the slower and more frustrating it becomes, whether in Excel, Power BI Desktop, or Power BI Service for Dataflows. What are your thoughts on this? Thanks a lot!Solved3.6KViews2likes8CommentsRe: Visual calculation : Conditional Formatting
Thanks Poojara 🙂 It does not solve my problem, but it answers my question. I am 100% based on a live connexion model, I do not want to go in Direct Query mode, so I cannot create new measures. Since I cannot modify the model, I am relying only on visual calculations to add new "measures" in my reports. I guess I will do without formatting for now. Thanks !3.4KViews1like0CommentsRe: Visual calculation : Conditional Formatting
Thanks lbendlin ! My visual calculation is Class = SWITCH( TRUE(), [Running sum (%)] > 0.95, "C", [Running sum (%)] > 0.8, "B", "A" ) I would like the background of A to be green, the background of B to be yellow and the background of C to be red. How can I achieve that with FORMAT ? Would it be something like this? Class = SWITCH( TRUE(), [Running sum (%)] > 0.95, FORMAT("C","red"), [Running sum (%)] > 0.8, FORMAT("B","yellow"), FORMAT("A","green") )3.6KViews0likes2CommentsRe: Visual calculation : Conditional Formatting
Hi guys, I am looking for the same solution here. I have a table visual with a visual calculation column. I would like to change the background color in this column according to each cell's value. However, visual calc do not appear in the conditional formatting options 😞 Any idea how we can do that? Thanks a lot, Christian3.7KViews0likes0CommentsRe: Visual calculation: running sum - sorting issue
Hi jeroenterheerdt ! I am very happy to have found this solution ! I would have imagined an ORDERBY parameter inside the running sum function, in able to choose the column to use to order the running sum. Thanks for working on this !8.6KViews3likes1Comment
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.