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.

     

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.