User Profile
yanlt
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Changing the Data tables and fields language
Hi all, We have Power BI Desktop and I have made a connection to our Project Server as my data source. While for the end user the UI (menus, buttons, fields names) is in English, when looking at the data source all the tables and fields are in presented Hebrew. What and how do I have to change so that the Power BI will present then in English? Thanks.Excel online - screen not scrolling
I'm using Excel online for a year now with Chrome browser , everything was OK till now. Suddenly scrolling horizontally beyond screen view is not working, meaning when I move the cell highlight with the keyboard the cell changes but the screen stays as is. Also the horizontal scrolling bar is not working. I tried then using Microsoft Edge and it is working OK. Any idea?Combine Data from Multiple Tables to 1 Pivot When Having Duplicate Values
See attached file. I have a table (Table1) with data of number of resources required every month per Product / per Domain / per Team. So a single product can appear many time in the 'product'column. Creating a Pivot for this Table1 is easy so I can see how much effort is required for each product or how much effort invests every Team along the year. I have many products & many department. Due to internal limitations, I have to divide Table1 so each department will get the same table structure but will fill in different required effort per month. So....I haveTable2 for Software andTable3 for Mechanics department and can have more tables for otherdepartment. I couldn't do it with the Pivot Data Model since 'Product' column contains duplicate values. So - How do I combine all the tables to 1 pivot or to 1 table and from there creating the pivot?When using Data Validation List with more then 8 values - drop down shows a black line
In column A I have a list of products. Incolumn D I have Data Validation List to select from column A values. When the List contains more than 8 values, when I open the list to select a value -it shows a black line. I'm using Excel 2016 MSO (16.0.4266.1001) 64-bit but it happened on other versions as well. Is it a known issue? Is there a solution?
