The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have few tables ('Oblast' and 'District') with columns named 'Name' and 'shapeID'.
I use 'shapeID' column to identify shape at Mapbox custom visual, and need to build a chart based on 'Name' column.
How can I get these two values from the one Fields Parameter slicer?
My Fields Parameter:
LocationSelector = {
("District", NAMEOF('District'[shapeID]), 0),
("Oblast", NAMEOF('Oblast'[shapeID]), 1)
}
If I try to make a new column, like the next, it returns just a text value:
LocationName = if(LocationSelector[LocationSelector]="District", NAMEOF('District'[Name]),
if(LocationSelector[LocationSelector]="Oblast", NAMEOF('Oblast'[Name])))
@Atoleto , Not very clear. But this how you get selected value of field parameter, Assume name is parameter
Selected Parameter = maxx(filter(Parameter ,Parameter[Parameter Order] = SELECTEDVALUE(Parameter[Parameter Order])), Parameter[Parameter])