Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Showing a chart with grouping based on parameter

I have a weekly number of issues, and each issue has a category: device_type, source, priority, site name.

How can I create a graph which shows the number of problems per week, but the splits will be different based on which categoty split I select?

e.g.

For the following graph, I picked a legend: Prio (priority), but I also want the user to pick other and this to update accordingly:

For prio:

MaWrob_0-1733232597040.png

For device category:

MaWrob_1-1733232642942.png

For site name:

MaWrob_2-1733232678958.png

 

1 ACCEPTED SOLUTION
sanalytics
Super User
Super User

@Anonymous 
Please use Field Parameter for that. There are tons of videos in Youtube regarding Field Parameter. Learn that concept and use that.

 

Hope it will help.

 

Regards

sanalytics

View solution in original post

3 REPLIES 3
sanalytics
Super User
Super User

@Anonymous 
Please use Field Parameter for that. There are tons of videos in Youtube regarding Field Parameter. Learn that concept and use that.

 

Hope it will help.

 

Regards

sanalytics

Anonymous
Not applicable

Thanks @sanalytics , I am following a tutorial on youtube and creating the parameter:
(each of these parameters are categorical

 

Parameter = {
("Device Category",NAMEOF(source[Device_category]),0),
("Site Name", NAMEOF(source[SiteName]),1),
("Prio", NAMEOF(source[Prio]),2),
("Completed", NAMEOF(source[Finished]),3)
}

 

 

But this gives me an error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
And I don't understand how to fix it in this context.

Chat GPT tell me to use the following but this does nto work either.

 

Parameter = {
    ("Device Category", source[Device_category], 0),
    ("Site Name", source[SiteName], 1),
    ("Prio", source[Prio], 2),
    ("Completed", source[Finished], 3)
}

 

 

 

Do you have a tip what is wrong with it?

Anonymous
Not applicable

I got it to work with picking fromt he ribbon "New parameter" rather than typing, and it looks the same to what I wrote, and this one works:

Parameter = {
    ("Device_category", NAMEOF('source'[Device_category]), 0),
    ("Finished", NAMEOF('source'[Finished]), 1),
    ("Prio", NAMEOF('source'[Prio]), 2),
    ("SiteName", NAMEOF('source'[SiteName]), 3),
    ("Source", NAMEOF('source'[Source]), 4),
    ("OTD", NAMEOF('source'[OTD]), 5)
}

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.