How to use Multiple columns in same visual

[LuisMedrano]

Hi all!

I hope there is a way to do what I want to do 

I have this table with the values I need to use in 2 different columns (Ton and Cases) and I want to switch between them in the same visuals (lines, bars, tables, etc) using a slicer or something different.

I used Unpivot option, however, I will exceed the number 1M rows soon if I do so.

Is there any other option I can use??

Tks for the support.

LM

Lima - Peru

[v-cherch-msft · Accepted solution]

Hi @LuisMedrano

Show a simplified sample as below. First, create the slicer table first. Second, create a measure to get the visual as requested. If it is not your case, please share more details for your scenario so that we could help further on it.

Measure =
IF (
    SELECTEDVALUE ( Slicer[Column1] ) = "Cases",
    CALCULATE ( SUM ( Table2[Cases] ) ),
    IF (
        SELECTEDVALUE ( Slicer[Column1] ) = "Ton",
        CALCULATE ( SUM ( Table2[Ton] ) )
    )
)

Regards,

Cherie

[TomMartens]

Hey,

I'm not sure if I understand your requirement correctly, but I think this post will provide what you are looking for:

https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/

If this is not the case, please consider to provide the sample data from your first post as a dataset that we can reuse easily, e.g. upload an Excel file to onedrive or dropbox and share the link.

And also explain in more detail how you visual should look like.

Regards,

Tom