Forum Discussion
Using a table visual, splitting the results into 2 columns
lc_finance I am not able to due to the sensativity of the data. However, I think what I need is a calculated measure.
To recap, I have two slicers that filtered down a list of report names into a matrix. A second matrix is being added, and the filtered report names need to be split so that one half is in matrix one, and one half in matrix two. I don't think the correct solution is to split the underlying data but instead to have the result of the two slicers split. Would you agree?
Hi Anonymous ,
Yes, I agree, we should split the result of the slicers into 2.
Calculated measures are the right way to do it because they take into account the result of all the slicers.
I understand about the confidential data. In that case, could you share a sample Power BI file where you put sample/fake data?
A Power BI example would be very helpful in understanding why the measures I proposed to you do not seem to work
LC
Interested in Power BI and DAX tutorials? Check out my blog at www.finance-bi.com