Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using a table visual, splitting the results into 2 columns

Hello,   I have a table with a single column, but I want the results to be split among two columns instead.              I understand I might need to use a DAX query for this, but how can...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

lc_financeI followed the steps now, and the list of report names changed, but the reports are still split unevenly. The split needs to happen after the slicer labeled D&M, TS, WS, and WL are applied.

 

The report names are not split evenly.

lc_finance's avatar
lc_finance
Solution Sage
6 years ago

Hi Anonymous ,

 

 

in that case, you can create a calculated measure instead of a calculated column.

Calculated measure take into account any filter that you apply to your Power BI.

 

You can use a slightly different DAX formula for the calculated measure:

Column number = 
VAR numberOfRows = COUNTROWS('Text')
VAR currentIndex = SELECTEDVALUE('Text'[Index])
RETURN IF (currentIndex<=numberOfRows/2 , 1,2)

 

Does this help you?

 

LC

Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com