Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I have the following design, and I want the specific provider's bar highlighted when selected in the slicer.
At the moment I have the bar chart not filtering due to edit interactions turned off.
Is there a way to do this?
Any assistance greatly appreciated. PBIX file linked below.
Filename Size URL Expires at
conditionalformatbarchart.pbix |
126.59 KB |
https://tmpfiles.org/dl/953823/conditionalformatbarchart.pbix |
2023-02-22 07:57 UTC
|
Solved! Go to Solution.
@johnmelbourne ,
refer video in this link:https://www.youtube.com/watch?v=DT3XTcXJxo4
1. Create a duplicate table of the column which is using in the slicer.
2. Write the below measure,
Conditional Formatting =
VAR _selectedBank = VALUES('Table 1 (Slicer)'[Bank])
VAR _result = IF(SELECTEDVALUE('Table 1'[Bank]) IN _selectedBank,1,0)
RETURN _result
3. In the slicer use the column from duplicated table i.e. from the slicer table,
4. Now bring the columns from source table for the visualization (bar chart),
5. Now click on any of the values in the slicer would make the bar chart interactive,
Thanks,
Arul
Thanks for your reply, worked execellently to format the bars in the visual.
Then just had to create a new measure for the visual I wanted to filter such as:
Total complaints (disconnected) using VALUES =
@johnmelbourne ,
refer video in this link:https://www.youtube.com/watch?v=DT3XTcXJxo4
1. Create a duplicate table of the column which is using in the slicer.
2. Write the below measure,
Conditional Formatting =
VAR _selectedBank = VALUES('Table 1 (Slicer)'[Bank])
VAR _result = IF(SELECTEDVALUE('Table 1'[Bank]) IN _selectedBank,1,0)
RETURN _result
3. In the slicer use the column from duplicated table i.e. from the slicer table,
4. Now bring the columns from source table for the visualization (bar chart),
5. Now click on any of the values in the slicer would make the bar chart interactive,
Thanks,
Arul
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
66 | |
60 |