Forum Discussion

greq_px's avatar
greq_px
Frequent Visitor
3 years ago

Create table based on measures where I have values in decimal number and percent

Hello everybody, I need your help with my problem. I have 3 category where each of them has 3 subcategory. I would like to create a chart where I would show percent values, and a table where I show ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

greq_px , Not very clear.

 

But check if this can help (field parameters)

 

Changing measures based on the axis with Field Parameters in Power BI. Dynamic measures based on the axis/Dimension: https://youtu.be/7ikRAelDph0

 

 

Or isinscope can help

IsInScope - Switch measure at different levels: https://youtu.be/kh0gezKICEM

greq_px's avatar
greq_px
Frequent Visitor
3 years ago

Its's very difficult to explain for me. But in digest: I want to have a solution where I can choose one category, one subcategory and see on chart percent values, and next to chart i want to have a matrix with a numerator, a denominator and a percent value which is result of division these two values. All values (on a chart and in a matrix) must be switch smoothly relevant of users choice. Each category have 3 subcategory and each subcategory have 3 values( numerator, denominator and percent value) :).