User Profile
R3muS10
Frequent Visitor
Joined 9 years ago
User Widgets
Contributions
How to rename a blank value in a matrix row or column
Hello. I am trying to make a matrix visualizations with some data in it. I have with a relationship between my tables. The matrix visualization has a blank row / column depending where I position that column, like in this picture: Is it any method to rename that column so that it won't show that blank space ? In my visualization filter it says (blank) like this: Thanks in advance. PS: Sorry about some of the words, they are in my native language (romanian).Solved19KViews0likes7CommentsRe: How to rename a blank value in a matrix row or column
Thank you for your responses Baskar KieranHarmon . Unfortunately the methods did not work :( . Maye i did something wrong or something, because I don't see any modifications to my code ... In my table I don't have any 'blank' spaces, but when I add it on the matrix row it appears because it interacts with another column in the table where the relantionship is. In the database i've got something like this:19KViews0likes3CommentsRe: Calculate From begining of year to current month
Anonymous Thank you for your response but that wasn't helpful enough, but it was perfect for another task thai I did and this way is better :D . For example I need to do this: In a PowerBi sheet I have a matrix and a slicer with months. Let's assume the database from a year it's from january to december. I need to change the '10' number with the number of months that I 'sliced'. Is there anyway that I can do that ? The thing is I want to do it dinamically and not to change the DAX formula every time I add or remove a month. Basically my reports will go to some clients that perhaps won't figure out the meaning behing a DAX function, because if I will do it further it wouldn't be a problem... Thanks in advance.1.4KViews0likes1CommentCalculate From begining of year to current month
Hello. I am trying to make a formula to calculate the SalaryFunds till the current month from the begining of the year. My formula is something like this: SalaryFundsFormula = CALCULATE(SUM(Salary_funds[Total_Spend]) / 10, Salary_funds[StructureId]) I need to calculate from January to October (because i only have in the database till october) but if my database will be populated further I need to change that '10' with a value that represents the last month in the database. I also have a datetime function (in my database there are only numbers from 1 to 10 so no datetime). I have tried with some time intelligence functions but I haven't got any good results :( . Does somebody know how to do something like this ? Thanks in advance. PS: If any data is required I can provide it.1.5KViews0likes3CommentsRe: Matrix columns and rows
Anonymous With a little bit of help of your screen shot I managed to make my Matrix visual in Power BI. All I needed to do was to un-pivot some columns in the database query and worked my way around that. I kept using the pivot and I didn't realize what was not working. dkay84_PowerBI Thank you for this tip. I created the columns ( Attributes & Values ) with the unpivot columns. Thank you for the help that you provided :) .9.7KViews0likes0CommentsMatrix columns and rows
Hello. I am new user to power bi. I tried to make a matrix with some database entries but it seems I can't get this right... I read almost everything about this on the forums and tutorials and I couldn't get anything to work. As the picture above is showing (a "matrix" created in Excel) I need to create some rows that are stored in the database with the names showed there and on columns I have some city names that I need to be stored there. How can I create this on a matrix visualization ? Any tips on how can I do it are deeply appreciated. Thanks in advance.Solved6.7KViews0likes3Comments
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.