User Profile
Jojo197
Helper I
Joined 4 years ago
User Widgets
Contributions
Re: Table Visual multiline column won't resize height automatically unless in first 20 columns
Hi Uzi2019 , I would share the file, but still trying to get around the organisation policy 😔 I have set up a sample demonstrating the issue with Columns A1 to Z26 and a multiline Test column in blue Resizing only happens when the blue column is in the first 20 columns Hope that makes it clearer Thanks!"NA" converts to na in measure
I have a matrix visual, with a single measure determining the values shown below. I can't seem to reproduce the issue with a simplified example, but in the following code, when MainTable[SectionHeader] (at the bottom) is the string "NA", the string "na" gets displayed on the matrix instead. I think this is due to some new update on power bi, as it was working perfectly fine previously. I've been able to fix it by adding on " " onto the end of each value, but it isn't exactly an elegant solution, and I was hoping someone in the community might have a better explanation/solution for me. Value = IF([Hide],BLANK(),IF(HASONEVALUE(DimCategories[Code]), SELECTEDVALUE(FactArchive[ValueFinal]), IF(CALCULATE( COUNTA(FactArchive[ValueFinal])=0, ALL(FactArchive),FactArchive[Code] in VALUES(DimCategories[Code]), DimHeaders[HeaderBU]=SELECTEDVALUE(DimHeaders[HeaderBU]) ),BLANK(),SELECTEDVALUE('MainTable'[SectionHeader])) ))Centered Text in Matrix Visual with Icons
I have a matrix visual with a column defining the rows and columns, and a single measure for the value in each cell. Under 'Specific Column' for this measure, I have clicked the center alignment, but the matrix is not properly centering the text as it is further to the right. Some of the measure values have newline varchar(10) characters, but I'm not sure if that is causing the issue. Does anyone know why this is happening? UPDATE: Issue was due to there being conditional format icons in some of the cells. Is there a way to have it centered properly even though there is an icon?Re: Centered Text in Matrix Visual with Icons
Hi danextian , because it's a matrix with a measure for the values field, there is only one column (the measure) that I can center align. And the newline character is required for the report I am working on as otherwise it would be unreadable (not shown in the screenshot though)Re: Sharepoint List API connection - published data source credentials - oath2 not an option
Some additional Info, If I use Sharepoint List instead of Online List, the edit credentials window looks exactly the same but gives the oauth2 option which is what I want. However this method is extremely slow for the size of my data so it is preferable if I can get the Online List to work.Re: Sharepoint List API connection - published data source credentials - oath2 not an option
Hi Pat, The method in that article is what I have been using currently (with a few slight differences) but the same issues are there of oauth2 authentication not being an option when I publish to power BI, which means I cannot authenticate the data source.
