User Profile
chenko90
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Merge Table Switching Column Selection
I have a very odd case that i've never seen before. I am trying to merge two dataflows together and i selected two columns in each dataflow as part of my merge. When i select the two columns it shows that i have matching rows but then when i press ok and let it load it shows me that no data is matching. When i open the merge to see whats going on, my columns are switched in order. I don't understand why power query is switching my column selection without me doing anything. As you can see in the image below column 1 in the first dataflow is showing as column 2 in the second dataflow even thought i had selected for both of them to be column 1.Re: One button for multiple bookmarks option
So something like this is what i want. I have the buttons as seen and i can select revenue and 2023 and it will show me that in the charts below, or i can select volume 2023 and it will show me that. My problem is I can't map the year to both revenue and volume button. I don't think parameters would work for me as each revenue and volume metric is a seperate column in my data.One button for multiple bookmarks option
Hi all, I have a visualization where I am looking at Revenue and Volume charts for year 2023,2022,and 2021. I would like a way where i can have a button to select revenue and then select any of the three years to see those specific charts. I am having trouble finding a simple way to make the year buttons work for both revenue and volume. I seem to only be able to set it up to work with one or the other. I am using bookmarks to build the views i want and mapping the buttons to those booksmarks. So my current problem is if I have revenue button selected and then i press 2023 it will go to revenue but if i press volume button it will still show revenue as that is where i mapped the 2023 button.... Hope this makes senese. Any help is much appreciated.Data duplicating in table when using two datasets
I have main dataset and I am trying to create an excel file that i input some additional adjustments in and i am linking the two files by a unique material identifier. The relationship is one to many. When i go to try and build a table with data from both datasets the numbers are not showing correctly. I am not sure what i am doing wrong. For context: the excel file, that i am linking to the main dataset, currently has one row and three columns. The columns are the unique identifier, another identifier and the adjustment amount. For whatever reason when i put the adjutment column in the table the number is showing up under all material numbers instead of just the one from the excel file. I highlighted the one where it should be. The highlighted column is coming from the excel file while the other columns are coming from the main dataset I am using. In theory, it should show zero for all rows except the highlighted one. What am i missing?
