Forum Discussion
greq_px
3 years agoFrequent Visitor
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 ...
amitchandak
Super User
3 years agogreq_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
3 years agoFrequent Visitor
I've solved this problem but I have a second which is relevant with data type on table. Unfortunatelly all values are show in decimal number. I need two values in decimal and third in percent. Any idea? 🙂 I've used a solution with two virtual tables based on measures and matched slicers to the same group.