Forum Discussion
zxl1031
Helper I
Helper ICreate a table to include measures
Hello everyone, I have 7 measures and I want to visualize them in a bar chart . X-axis is the measure name (sorted from "0%", "<5%", "5%-10%" etc.), Y-axis is the caulcated value of each measure. ...
zxl1031 , In the second table filter will not apply. As New table will not tabke slicer value.
Instead of so many measures try to use the approch of dynamic segmentation
https://www.youtube.com/watch?v=CuczXPj0N-k
Create an independent table, With ranges , create new measures with a row context.
Hi zxl1031,
Current power bi does not support create dynamic calculated tables/columns based on filters or slicers. Please write measure expressions and use them with category to instead.
Category =
UNION (
ROW ( "cat", ">50%", "groupid", 1 ),
ROW ( "cat", "30%-40%", "groupid", 2 ),
ROW ( "cat", "20%-30%", "groupid", 3 ),
ROW ( "cat", "10%-20%", "groupid", 4 ),
ROW ( "cat", "5%-10%", "groupid", 5 ),
ROW ( "cat", "<5%", "groupid", 6 ),
ROW ( "cat", "0%", "groupid", 7 )
)
Measure =
VAR selection =
SELECTEDVALUE ( Category[cat] )
RETURN
SWITCH (
selection,
">50%", [>50%],
"30%-40%", [30%-40%],
"20%-30%", [20%-30%],
"10%-20%", [10%-20%],
"5%-10%", [5%-10%],
"<5%", [<5%],
"0%", [0%]
)
Notice: the data level of power bi.
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng