Forum Discussion

Henrique_Quint's avatar
Henrique_Quint
Helper I
1 year ago
Solved

Divide measure by parameter

Hello, everyone!   I have a parameter that has two measures (revenue) as fields. What I have now is a bar chart that has two Y axis changes one of its Y axis as this parameter that changes when I c...
Need Help
  • uzuntasgokberk's avatar
    uzuntasgokberk
    1 year ago

    Hello Henrique_Quint ,

    You have line in your image. But in the x axis there is only one value that's why it is showed "dot". However, x-axis will increase that will be shown as a line. And if you'd like to change the value of line based on selected slicer you can create a measure like:
    "test = IF(SELECTEDVALUE(FieldTab[Fieldcol])="Field1",[Measure1],[Measure2])"

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

uzuntasgokberk's avatar
uzuntasgokberk
Super User
1 year ago

Hello Henrique_Quint ,

You have line in your image. But in the x axis there is only one value that's why it is showed "dot". However, x-axis will increase that will be shown as a line. And if you'd like to change the value of line based on selected slicer you can create a measure like:
"test = IF(SELECTEDVALUE(FieldTab[Fieldcol])="Field1",[Measure1],[Measure2])"

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |