Forum Discussion

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

How do I combine two visuals reports into one Power BI visual report

Hi,   I have the following columns are Id, Code, Result1 and Result2 in data table. The same id and code has two different status.   I am currently using two different visual for same id and code...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Create a new table either via the query editor or a DAX calculated table.

     

    As a calculated table, for example:

    Slicer = DATATABLE ( "Result", STRING, {{"Result 1"}, {"Result 2"}} )

     

    See attached.

     

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
4 years ago

AlexisOlson

 

Can you please advise one more thing here, I would like achieve the same result by using New calculate column instead of measure. Is that possible?

  • So I can use the Var results in row and column for count and additional reporting purposes. 
  • The current Var results unable to use count 

 

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

A calculated column cannot read a slicer, so no, there isn't an equivalent for a calculated column.

  • Saxon10's avatar
    Saxon10
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Thanks for your reply and advise.