Forum Discussion
Post ProdigyHow do I combine two visuals reports into one Power BI visual report
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.
Post Prodigy
AlexisOlson , Thanks for your reply.
Desired Result:
I am trying to control Result1 and Result2 columns by using slicer. If I select Result1 column then it will only showing Result1 row, columns and value in visual (ignore the Result2 values and headers in visual). And the same logic apply for Result1 as well.
Current method:
I am currently using two differnt visual for Result1 and Result2 in visual. I would like to use one visual for both results by using slicer for result column.
Example:
Selection only for Result1 only.
Selection only for Result2 only.
Super UserDefine a new table Slicer with a single column "Result 1" and "Result 2".
Then you can define a measure
VarResult =
SWITCH (
SELECTEDVALUE ( Slicer[Result] ),
"Result 1", SELECTEDVALUE ( Data[Result 1] ),
"Result 2", SELECTEDVALUE ( Data[Result 2] )
)
- Saxon10
Hi AlexisOlson
Thank you so much for your reply and help.
I am struggling for step 1 so could you please kindly advise.
"Define a new table Slicer with a single column "Result 1" and "Result 2"
Could you please attached your final results final it's really help to understand the solution.
This is somthing new for me to learn it.
- AlexisOlson
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
Hi AlexisOlson
Thanks so much for your quick response and support.
This is really amazing and now I can control the status with in the same visual.
And more question regarding this topic.
How can I apply the conditional formatting here.
I used lot of different colours codes for both results.
Now how can I apply the conditional formatting according to the results 1 and result 2.
- Saxon10
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
A calculated column cannot read a slicer, so no, there isn't an equivalent for a calculated column.
- Saxon10
Thanks for your reply and advise.